5. Geospatial Functions : Envelope
 
Share this page                  
Envelope
ENVELOPE(g Geometry)
Alias: ST_ENVELOPE
Returns the bounding-box for g.
Result type: geometry
Example:
SELECT ASTEXT(ENVELOPE(POLYFROMTEXT('POLYGON((0 0,10 0,5 10,0 0))')));
--------------------------------
col1
--------------------------------
POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))
--------------------------------