Project

General

Profile

« Previous | Next » 

Revision 13907

schemas/util.sql: added south_america(), in_south_america()

View differences:

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