Revision 13904
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 2169 | 2169 |
|
| 2170 | 2170 |
|
| 2171 | 2171 |
-- |
| 2172 |
-- Name: in_new_world(geocoord); Type: FUNCTION; Schema: util; Owner: - |
|
| 2173 |
-- |
|
| 2174 |
|
|
| 2175 |
CREATE FUNCTION in_new_world(point geocoord) RETURNS boolean |
|
| 2176 |
LANGUAGE sql IMMUTABLE |
|
| 2177 |
AS $_$ |
|
| 2178 |
/* use function rather than operator+search_path to allow inlining, which |
|
| 2179 |
enables util.new_world() to only be evaluated once */ |
|
| 2180 |
SELECT util.contained_within_approx($1, util.new_world()) |
|
| 2181 |
$_$; |
|
| 2182 |
|
|
| 2183 |
|
|
| 2184 |
-- |
|
| 2185 |
-- Name: FUNCTION in_new_world(point geocoord); Type: COMMENT; Schema: util; Owner: - |
|
| 2186 |
-- |
|
| 2187 |
|
|
| 2188 |
COMMENT ON FUNCTION in_new_world(point geocoord) IS ' |
|
| 2189 |
**WARNING**: this includes false positives above and below the New World |
|
| 2190 |
bounding box, as described in util.bounding_box() |
|
| 2191 |
'; |
|
| 2192 |
|
|
| 2193 |
|
|
| 2194 |
-- |
|
| 2172 | 2195 |
-- Name: in_reverse(anyarray); Type: FUNCTION; Schema: util; Owner: - |
| 2173 | 2196 |
-- |
| 2174 | 2197 |
|
| ... | ... | |
| 2380 | 2403 |
|
| 2381 | 2404 |
|
| 2382 | 2405 |
-- |
| 2383 |
-- Name: lat_long_in_new_world(geocoord); Type: FUNCTION; Schema: util; Owner: - |
|
| 2384 |
-- |
|
| 2385 |
|
|
| 2386 |
CREATE FUNCTION lat_long_in_new_world(point geocoord) RETURNS boolean |
|
| 2387 |
LANGUAGE sql IMMUTABLE |
|
| 2388 |
AS $_$ |
|
| 2389 |
/* use function rather than operator+search_path to allow inlining, which |
|
| 2390 |
enables util.new_world() to only be evaluated once */ |
|
| 2391 |
SELECT util.contained_within_approx($1, util.new_world()) |
|
| 2392 |
$_$; |
|
| 2393 |
|
|
| 2394 |
|
|
| 2395 |
-- |
|
| 2396 |
-- Name: FUNCTION lat_long_in_new_world(point geocoord); Type: COMMENT; Schema: util; Owner: - |
|
| 2397 |
-- |
|
| 2398 |
|
|
| 2399 |
COMMENT ON FUNCTION lat_long_in_new_world(point geocoord) IS ' |
|
| 2400 |
**WARNING**: this includes false positives above and below the New World |
|
| 2401 |
bounding box, as described in util.bounding_box() |
|
| 2402 |
'; |
|
| 2403 |
|
|
| 2404 |
|
|
| 2405 |
-- |
|
| 2406 | 2406 |
-- Name: limit2row_num(integer, integer, integer); Type: FUNCTION; Schema: util; Owner: - |
| 2407 | 2407 |
-- |
| 2408 | 2408 |
|
Also available in: Unified diff
schemas/util.sql: lat_long_in_new_world(): renamed to just in_new_world() because the lat/long is implied by the param type