Revision 13822
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1049 | 1049 |
|
| 1050 | 1050 |
|
| 1051 | 1051 |
-- |
| 1052 |
-- Name: contained_within(postgis.geography, postgis.geography); Type: FUNCTION; Schema: util; Owner: - |
|
| 1053 |
-- |
|
| 1054 |
|
|
| 1055 |
CREATE FUNCTION contained_within("inner" postgis.geography, "outer" postgis.geography) RETURNS boolean
|
|
| 1056 |
LANGUAGE sql IMMUTABLE |
|
| 1057 |
SET search_path TO postgis |
|
| 1058 |
AS $_$ |
|
| 1059 |
/* search_path: st_coveredby() needs postgis to be in the search_path */ |
|
| 1060 |
SELECT postgis.st_coveredby($1, $2) |
|
| 1061 |
$_$; |
|
| 1062 |
|
|
| 1063 |
|
|
| 1064 |
-- |
|
| 1052 | 1065 |
-- Name: contains(text, text); Type: FUNCTION; Schema: util; Owner: - |
| 1053 | 1066 |
-- |
| 1054 | 1067 |
|
| ... | ... | |
| 4712 | 4725 |
-- |
| 4713 | 4726 |
|
| 4714 | 4727 |
CREATE OPERATOR @ ( |
| 4715 |
PROCEDURE = postgis.st_coveredby,
|
|
| 4728 |
PROCEDURE = contained_within,
|
|
| 4716 | 4729 |
LEFTARG = postgis.geography, |
| 4717 | 4730 |
RIGHTARG = postgis.geography |
| 4718 | 4731 |
); |
Also available in: Unified diff
bugfix: schemas/util.sql: operator @(postgis.geography, postgis.geography): must use wrapper function because st_coveredby() needs postgis to be in the search_path