ST_IntersectionAggr method

ST_Geometry::ST_IntersectionAggr(geometry-column)

Name	Type	Description
geometry-column	ST_Geometry	The geometry values to generate the spatial intersection. Typically this is a column.

ST_Geometry Returns a geometry that is the spatial intersection for all the geometries in a group.
The spatial reference system identifier of the result is the same as that for the first parameter.

Rows where the argument is NULL are not included.

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

If the group contains a single non-NULL geometry, it is returned. Otherwise, the intersection is logically computed by repeatedly applying the ST_Intersection method to combine two geometries at a time. See ST_Intersection method for type ST_Geometry.

ST_Intersection method for type ST_Geometry

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

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 )

ST_IntersectionAggr method

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example