SupportsBBox - Amazon Redshift

SupportsBBox

SupportsBBox returns true if the input geometry supports encoding with a precomputed bounding box. For more information about support for bounding boxes, see Bounding box.

Syntax

SupportsBBox(geom)

Arguments

geom

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

Return type

BOOLEAN

If geom is null, then null is returned.

Examples

The following SQL returns true because the input point geometry supports being encoded with a bounding box.

SELECT SupportsBBox(AddBBox(ST_GeomFromText('POLYGON((0 0,1 0,0 1,0 0))')));
supportsbbox -------------- t

The following SQL returns false because the input point geometry doesn't support being encoded with a bounding box.

SELECT SupportsBBox(DropBBox(ST_GeomFromText('POLYGON((0 0,1 0,0 1,0 0))')));
supportsbbox -------------- f