ST_IntersectionAggr( ST_Geometry ) method

Syntax

ST_Geometry::ST_IntersectionAggr( ST_Geometry geometry_column)

Parameters

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

Returns

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

Examples

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

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

Standards

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