Revision 13905
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1109 | 1109 |
|
| 1110 | 1110 |
|
| 1111 | 1111 |
-- |
| 1112 |
-- Name: contained_within__no_dateline(geocoord, postgis.geometry); Type: FUNCTION; Schema: util; Owner: - |
|
| 1113 |
-- |
|
| 1114 |
|
|
| 1115 |
CREATE FUNCTION contained_within__no_dateline(point geocoord, region postgis.geometry) RETURNS boolean |
|
| 1116 |
LANGUAGE sql IMMUTABLE |
|
| 1117 |
AS $_$ |
|
| 1118 |
SELECT util.contained_within__no_dateline(util.geometry($1), $2) |
|
| 1119 |
$_$; |
|
| 1120 |
|
|
| 1121 |
|
|
| 1122 |
-- |
|
| 1123 |
-- Name: FUNCTION contained_within__no_dateline(point geocoord, region postgis.geometry); Type: COMMENT; Schema: util; Owner: - |
|
| 1124 |
-- |
|
| 1125 |
|
|
| 1126 |
COMMENT ON FUNCTION contained_within__no_dateline(point geocoord, region postgis.geometry) IS ' |
|
| 1127 |
defining this in addition to contained_within_approx(geometry, geometry) enables |
|
| 1128 |
specifying just `(lat, long)` without the ::util.geocoord type specifier |
|
| 1129 |
'; |
|
| 1130 |
|
|
| 1131 |
|
|
| 1132 |
-- |
|
| 1112 | 1133 |
-- Name: contained_within_approx(postgis.geography, postgis.geography); Type: FUNCTION; Schema: util; Owner: - |
| 1113 | 1134 |
-- |
| 1114 | 1135 |
|
| ... | ... | |
| 1154 | 1175 |
|
| 1155 | 1176 |
|
| 1156 | 1177 |
-- |
| 1157 |
-- Name: contained_within_approx(geocoord, postgis.geometry); Type: FUNCTION; Schema: util; Owner: - |
|
| 1158 |
-- |
|
| 1159 |
|
|
| 1160 |
CREATE FUNCTION contained_within_approx(point geocoord, region postgis.geometry) RETURNS boolean |
|
| 1161 |
LANGUAGE sql IMMUTABLE |
|
| 1162 |
AS $_$ |
|
| 1163 |
SELECT util.contained_within_approx(util.geometry($1), $2) |
|
| 1164 |
$_$; |
|
| 1165 |
|
|
| 1166 |
|
|
| 1167 |
-- |
|
| 1168 |
-- Name: FUNCTION contained_within_approx(point geocoord, region postgis.geometry); Type: COMMENT; Schema: util; Owner: - |
|
| 1169 |
-- |
|
| 1170 |
|
|
| 1171 |
COMMENT ON FUNCTION contained_within_approx(point geocoord, region postgis.geometry) IS ' |
|
| 1172 |
defining this in addition to contained_within_approx(geometry, geometry) enables |
|
| 1173 |
specifying just `(lat, long)` without the ::util.geocoord type specifier |
|
| 1174 |
'; |
|
| 1175 |
|
|
| 1176 |
|
|
| 1177 |
-- |
|
| 1178 | 1178 |
-- Name: contains(text, text); Type: FUNCTION; Schema: util; Owner: - |
| 1179 | 1179 |
-- |
| 1180 | 1180 |
|
| ... | ... | |
| 4951 | 4951 |
-- |
| 4952 | 4952 |
|
| 4953 | 4953 |
CREATE OPERATOR ~@ ( |
| 4954 |
PROCEDURE = contained_within_approx,
|
|
| 4954 |
PROCEDURE = contained_within__no_dateline,
|
|
| 4955 | 4955 |
LEFTARG = geocoord, |
| 4956 | 4956 |
RIGHTARG = postgis.geometry |
| 4957 | 4957 |
); |
Also available in: Unified diff
fix: schemas/util.sql: contained_within_approx(geocoord, postgis.geometry): renamed to contained_within__no_dateline(__) because this is not an approximate comparison for geometry