AddBBox - Amazon Redshift

AddBBox

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

Syntax

AddBBox(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 supports being encoded with a bounding box.

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