Skip to main content
Return the symmetrical difference between geometry A and B (return parts of geometries which are in either of the sets, but not in their intersection) ST_SymDifference

​
Signatures

ST_SymDifference (A: Geometry, B: Geometry)

​
Parameters

​
A
Geometry
required
The input geometry.
​
B
Geometry
required
The second geometry.

​
Return type

The resulting geometry.

​
Example

SELECT ST_SymDifference(ST_GeomFromWKT('POLYGON ((-3 -3, 3 -3, 3 3, -3 3, -3 -3))'), ST_GeomFromWKT('POLYGON ((-2 -3, 4 -3, 4 3, -2 3, -2 -3))'))

MULTIPOLYGON (((-2 -3, -3 -3, -3 3, -2 3, -2 -3)), ((3 -3, 3 3, 4 3, 4 -3, 3 -3)))