ST_UnionAggr( ST_Geometry ) method

Syntax

ST_Geometry::ST_UnionAggr( ST_Geometry geometry_column)

Parameters

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

Returns

ST_Geometry Returns a geometry that is the spatial union for all the geometries in a group.

Examples

• Example 1 – The following example returns the result Polygon ((.555555 3, 0 3, 0 1.75, 0 0, 3 0, 3 3, .75 3, 1 4, .555555 3)).

  SELECT ST_Geometry::ST_UnionAggr( Shape )
  FROM SpatialShapes WHERE ShapeID IN ( 2, 6 )

Standards

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