Revision 13799
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/util.sql | ||
---|---|---|
714 | 714 |
|
715 | 715 |
|
716 | 716 |
-- |
717 |
-- Name: bounding_box(numrange, numrange); Type: FUNCTION; Schema: util; Owner: - |
|
718 |
-- |
|
719 |
|
|
720 |
CREATE FUNCTION bounding_box(latitude_range_deg numrange, longitude_range_deg numrange) RETURNS postgis.box2d |
|
721 |
LANGUAGE sql IMMUTABLE |
|
722 |
SET search_path TO postgis |
|
723 |
AS $_$ |
|
724 |
SELECT st_makebox2d( |
|
725 |
/*pointLowLeft=*/st_point(/*x_lon=*/lower($2), /*y_lat=*/lower($1)) |
|
726 |
, /*pointUpRight=*/st_point(/*x_lon=*/upper($2), /*y_lat=*/upper($1)) |
|
727 |
) |
|
728 |
$_$; |
|
729 |
|
|
730 |
|
|
731 |
-- |
|
717 | 732 |
-- Name: cast(text, anyelement); Type: FUNCTION; Schema: util; Owner: - |
718 | 733 |
-- |
719 | 734 |
|
Also available in: Unified diff
schemas/util.sql: added bounding_box()