Top

Name

st_get_bounding_box_n — Given a 1-based index of a member of a MULTI... or ...COLLECTION shape, returns the bounding box of a member.

Synopsis

st_get_bounding_box_n ( in shape any ,
  in idx any );
 

Description

Given a 1-based index of a member of a MULTI... or ...COLLECTION shape, returns the bounding box of a member. This is a fast equivalent of st_get_bounding_box_n(ST_GeometryN (shape,idx)) .

Parameters

shape

Shape

idx

Index

Return Types

Returns any.

Examples

Example 24.662. Simple Use 

SQL> select st_get_bounding_box_n (
              st_ewkt_read ('
                GEOMETRYCOLLECTION(
                  POINT(0 0),
                  MULTILINESTRING(
                    (1 5,0 1,4 0,5 4),
                    (1 5,1 0,4 0,4 5)),
                  MULTIPOLYGON(
                    ((1 3,2 4,1 5,0 4,1 3)),
                    ((1 2,2 1,1 0,0 1,1 2))))'), 1)
unnamed
VARCHAR NOT NULL
_______________________________________________________________________________

BOX2D(0.0 0.0,0.0 0.0)

SQL> select st_get_bounding_box_n (
              st_ewkt_read ('
                GEOMETRYCOLLECTION(
                  POINT(0 0),
                  MULTILINESTRING(
                    (1 5,0 1,4 0,5 4),
                    (1 5,1 0,4 0,4 5)),
                  MULTIPOLYGON(
                    ((1 3,2 4,1 5,0 4,1 3)),
                    ((1 2,2 1,1 0,0 1,1 2))))'), 2)
unnamed
VARCHAR NOT NULL
_______________________________________________________________________________

BOX2D(0.0 0.0,5.000001 5.000001)

Prev  Up  Next
st_get_bounding_box   Home  haversine_deg_km