Revision 13898
Added by Aaron Marcuse-Kubitza over 10 years ago
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
schemas/util.sql: added contained_within_approx(geocoord, postgis.geography), which enables specifying just `(lat, long)` without the ::util.geocoord type specifier