DropBBox - Amazon Redshift

DropBBox

DropBBox returns a copy of the input geometry that doesn't support encoding with a precomputed bounding box. For more information about support for bounding boxes, see Bounding box.

Syntax

DropBBox(geom)

Arguments

geom

A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

GEOMETRY

If geom is null, then null is returned.

Examples

The following SQL returns a copy of an input polygon geometry that doesn't support being encoded with a bounding box.

SELECT ST_AsText(DropBBox(ST_GeomFromText('POLYGON((0 0,1 0,0 1,0 0))')));
st_astext ---------- POLYGON((0 0,1 0,0 1,0 0))