Skip to main content
Return the polygon intersection of all polygons in A ST_Intersection_Agg

​
Signatures

ST_Intersection_Agg (A: geometryColumn)

​
Parameters

​
A
geometryColumn
required
The input geometry.

​
Return type

The resulting geometry.
This function was previously named ST_Intersection_Aggr, which is deprecated since v1.8.1.

​
Example

SELECT ST_Intersection_Agg(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1 103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)'))

MULTIPOINT ((1.1 101.1), (2.1 102.1), (3.1 103.1), (4.1 104.1), (5.1 105.1), (6.1 106.1), (7.1 107.1), (8.1 108.1), (9.1 109.1), (10.1 110.1))