ST_Envelope_Agg¶

Introduction: Return the entire envelope boundary of all geometries in A. Empty geometries and null values are skipped. If all inputs are empty or null, the result is null. This behavior is consistent with PostGIS's ST_Extent.

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))