ST_GeomCollectionAggr( ST_Geometry ) method

Syntax

ST_GeomCollection::ST_GeomCollectionAggr( ST_Geometry geometry_column)

Parameters

• geometry_column – The geometry values to generate the collection. Typically this is a column.

Returns

ST_GeomCollection Returns a geometry collection that contains all of the geometries in a group.

Examples

• Example 1 – 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

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension