ST_GeomCollection::ST_GeomCollectionAggr(geometry-column[ ORDER BY order-by-expression [ ASC | DESC ], ... ] )

The ST_GeomCollectionAggr aggregate function can be used to combine a group of geometries into a single collection. All of the geometries to be combined must have both the same SRID and the same coordinate dimension.

Rows where the argument is NULL are not included.

Returns NULL for an empty group or a group containing no non-NULL values.

The resulting ST_GeomCollection has the same coordinate dimension as each geometries.

The optional ORDER BY clause can be used to arrange the elements in a particular order so that ST_GeometryN returns them in the desired order. If this ordering is not relevant, it is more efficient to not specify an ordering. In that case, the ordering of elements depends on the access plan selected by the query optimizer.

ST_GeomCollectionAggr is more efficient than ST_UnionAggr, but ST_GeomCollectionAggr can return a collection with duplicate or overlapping geometries if they exist in the group of geometries. In particular, returned collections containing overlapping surfaces may case unexpected results if they are used as input to other spatial methods. ST_UnionAggr handles duplicate and overlapping geometries.

• ST_UnionAggr method for type ST_Geometry

The following example returns a single value which combines all geometries from the SpatialShapes table into a single collection.

SELECT ST_GeomCollection::ST_GeomCollectionAggr( Shape ) FROM SpatialShapes
	WHERE Shape.ST_Is3D() = 0