List of set operation methods

The following is a list of set operation methods available for use with spatial data. An X in the Round-Earth column indicates that the method is also supported on round-Earth spatial reference systems. The SQL/MM column reflects compliance with the SQL/MM standard (ISO/IEC 13249-3: 2006).

Method Type Description Round-Earth SQL/MM
ST_Difference method ST_Geometry type

Returns the geometry value that represents the point set difference of two geometries.

X 5.1.20
ST_Intersection method ST_Geometry type

Returns the geometry value that represents the point set intersection of two geometries.

X 5.1.18
ST_IntersectionAggr method ST_Geometry type

Returns the spatial intersection of all of the geometries in a group

X Vendor extension
ST_SymDifference method ST_Geometry type

Returns the geometry value that represents the point set symmetric difference of two geometries.

X 5.1.21
ST_Union method ST_Geometry type

Returns the geometry value that represents the point set union of two geometries.

X 5.1.19
ST_UnionAggr method ST_Geometry type

Returns the spatial union of all of the geometries in a group

X Vendor extension