Project

General

Profile

« Previous | Next » 

Revision 13799

schemas/util.sql: added bounding_box()

View differences:

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