SupportsBBox - Amazon Redshift
SyntaxArgumentsReturn typeExamples

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