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
Example24.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)