ST_Envelope_Agg¶

Introduction: Return the entire envelope boundary of all geometries in A

ST_Envelope_Agg

Format: ST_Envelope_Agg (A: geometryColumn)

Return type: Geometry

Since: v1.3.0

Note

This function was previously named ST_Envelope_Aggr, which is deprecated since v1.8.1.

Example:

SELECT ST_Envelope_Agg(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1 103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)'))

Output:

POLYGON ((1.1 101.1, 1.1 120.1, 20.1 120.1, 20.1 101.1, 1.1 101.1))