Skip to main content
This variant of ST_Union operates on a single geometry input. The input geometry can be a simple Geometry type, a MultiGeometry, or a GeometryCollection. The function calculates the geometric union across all components and elements within the provided geometry object. ST_UnaryUnion

​
Signatures

ST_UnaryUnion(geometry: Geometry)

​
Parameters

​
geometry
Geometry
required
The input geometry.

​
Return type

The resulting geometry.

​
Example

SELECT ST_UnaryUnion(ST_GeomFromWKT('MULTIPOLYGON(((0 10,0 30,20 30,20 10,0 10)),((10 0,10 20,30 20,30 0,10 0)))'))

POLYGON ((10 0, 10 10, 0 10, 0 30, 20 30, 20 20, 30 20, 30 0, 10 0))