Skip to main content
Collects all geometries in a geometry column into a single multi-geometry (MultiPoint, MultiLineString, MultiPolygon, or GeometryCollection). Unlike ST_Union_Agg, this function does not dissolve boundaries between geometries - it simply collects them into a multi-geometry. ST_Collect_Agg

​
Signatures

ST_Collect_Agg (A: geometryColumn)

​
Parameters

​
A
geometryColumn
required
The input geometry.

​
Return type

The resulting geometry.

​
Examples

SELECT ST_Collect_Agg(geom) FROM (
  SELECT ST_GeomFromWKT('POINT(1 2)') AS geom
  UNION ALL
  SELECT ST_GeomFromWKT('POINT(3 4)') AS geom
  UNION ALL
  SELECT ST_GeomFromWKT('POINT(5 6)') AS geom
)

MULTIPOINT ((1 2), (3 4), (5 6))

​
with GROUP BY

SELECT category, ST_Collect_Agg(geom) FROM geometries GROUP BY category