Project

General

Profile

« Previous | Next » 

Revision 13898

schemas/util.sql: added contained_within_approx(geocoord, postgis.geography), which enables specifying just `(lat, long)` without the ::util.geocoord type specifier

View differences:

trunk/schemas/util.sql
1133 1133

  
1134 1134

  
1135 1135
--
1136
-- Name: contained_within_approx(geocoord, postgis.geography); Type: FUNCTION; Schema: util; Owner: -
1137
--
1138

  
1139
CREATE FUNCTION contained_within_approx(point geocoord, region postgis.geography) RETURNS boolean
1140
    LANGUAGE sql IMMUTABLE
1141
    AS $_$
1142
SELECT util.contained_within_approx(util.geometry($1), $2)
1143
$_$;
1144

  
1145

  
1146
--
1147
-- Name: FUNCTION contained_within_approx(point geocoord, region postgis.geography); Type: COMMENT; Schema: util; Owner: -
1148
--
1149

  
1150
COMMENT ON FUNCTION contained_within_approx(point geocoord, region postgis.geography) IS '
1151
defining this in addition to contained_within_approx(geography, geography)
1152
enables specifying just `(lat, long)` without the ::util.geocoord type specifier
1153
';
1154

  
1155

  
1156
--
1136 1157
-- Name: contains(text, text); Type: FUNCTION; Schema: util; Owner: -
1137 1158
--
1138 1159

  

Also available in: Unified diff