Revision 13907
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/util.sql | ||
---|---|---|
2203 | 2203 |
|
2204 | 2204 |
|
2205 | 2205 |
-- |
2206 |
-- Name: in_south_america(geocoord); Type: FUNCTION; Schema: util; Owner: - |
|
2207 |
-- |
|
2208 |
|
|
2209 |
CREATE FUNCTION in_south_america(point geocoord) RETURNS boolean |
|
2210 |
LANGUAGE sql IMMUTABLE |
|
2211 |
AS $_$ |
|
2212 |
/* use function rather than operator+search_path to allow inlining, which |
|
2213 |
enables util.south_america() to only be evaluated once */ |
|
2214 |
SELECT util.contained_within_approx($1, util.south_america()) |
|
2215 |
$_$; |
|
2216 |
|
|
2217 |
|
|
2218 |
-- |
|
2206 | 2219 |
-- Name: inherit(regclass, regclass); Type: FUNCTION; Schema: util; Owner: - |
2207 | 2220 |
-- |
2208 | 2221 |
|
... | ... | |
4304 | 4317 |
|
4305 | 4318 |
|
4306 | 4319 |
-- |
4320 |
-- Name: south_america(); Type: FUNCTION; Schema: util; Owner: - |
|
4321 |
-- |
|
4322 |
|
|
4323 |
CREATE FUNCTION south_america() RETURNS postgis.geometry |
|
4324 |
LANGUAGE sql IMMUTABLE |
|
4325 |
SET search_path TO util |
|
4326 |
AS $$ |
|
4327 |
SELECT util.bounding_box__no_dateline(-56 ~ 13, -82 ~ -34) |
|
4328 |
$$; |
|
4329 |
|
|
4330 |
|
|
4331 |
-- |
|
4307 | 4332 |
-- Name: str_equality_regexp(text); Type: FUNCTION; Schema: util; Owner: - |
4308 | 4333 |
-- |
4309 | 4334 |
|
trunk/schemas/vegbien.my.sql | ||
---|---|---|
1374 | 1374 |
|
1375 | 1375 |
|
1376 | 1376 |
-- |
1377 |
-- Name: in_south_america(util.geocoord); Type: FUNCTION; Schema: public; Owner: - |
|
1378 |
-- |
|
1379 |
|
|
1380 |
|
|
1381 |
|
|
1382 |
|
|
1383 |
-- |
|
1384 |
-- Name: FUNCTION in_south_america(point util.geocoord); Type: COMMENT; Schema: public; Owner: - |
|
1385 |
-- |
|
1386 |
|
|
1387 |
|
|
1388 |
|
|
1389 |
|
|
1390 |
-- |
|
1377 | 1391 |
-- Name: location__pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: - |
1378 | 1392 |
-- |
1379 | 1393 |
|
trunk/schemas/public_.sql | ||
---|---|---|
2202 | 2202 |
|
2203 | 2203 |
|
2204 | 2204 |
-- |
2205 |
-- Name: in_south_america(util.geocoord); Type: FUNCTION; Schema: public; Owner: - |
|
2206 |
-- |
|
2207 |
|
|
2208 |
CREATE FUNCTION in_south_america(point util.geocoord) RETURNS boolean |
|
2209 |
LANGUAGE sql IMMUTABLE |
|
2210 |
AS $_$ |
|
2211 |
SELECT util.in_south_america($1) |
|
2212 |
$_$; |
|
2213 |
|
|
2214 |
|
|
2215 |
-- |
|
2216 |
-- Name: FUNCTION in_south_america(point util.geocoord); Type: COMMENT; Schema: public; Owner: - |
|
2217 |
-- |
|
2218 |
|
|
2219 |
COMMENT ON FUNCTION in_south_america(point util.geocoord) IS ' |
|
2220 |
wrapper that prevents views from getting dropped when the util schema is reinstalled |
|
2221 |
'; |
|
2222 |
|
|
2223 |
|
|
2224 |
-- |
|
2205 | 2225 |
-- Name: location__pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: - |
2206 | 2226 |
-- |
2207 | 2227 |
|
trunk/schemas/vegbien.sql | ||
---|---|---|
2202 | 2202 |
|
2203 | 2203 |
|
2204 | 2204 |
-- |
2205 |
-- Name: in_south_america(util.geocoord); Type: FUNCTION; Schema: public; Owner: - |
|
2206 |
-- |
|
2207 |
|
|
2208 |
CREATE FUNCTION in_south_america(point util.geocoord) RETURNS boolean |
|
2209 |
LANGUAGE sql IMMUTABLE |
|
2210 |
AS $_$ |
|
2211 |
SELECT util.in_south_america($1) |
|
2212 |
$_$; |
|
2213 |
|
|
2214 |
|
|
2215 |
-- |
|
2216 |
-- Name: FUNCTION in_south_america(point util.geocoord); Type: COMMENT; Schema: public; Owner: - |
|
2217 |
-- |
|
2218 |
|
|
2219 |
COMMENT ON FUNCTION in_south_america(point util.geocoord) IS ' |
|
2220 |
wrapper that prevents views from getting dropped when the util schema is reinstalled |
|
2221 |
'; |
|
2222 |
|
|
2223 |
|
|
2224 |
-- |
|
2205 | 2225 |
-- Name: location__pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: - |
2206 | 2226 |
-- |
2207 | 2227 |
|
Also available in: Unified diff
schemas/util.sql: added south_america(), in_south_america()