Skip to main content
Return the difference between geometry A and B (return part of geometry A that does not intersect geometry B) ST_Difference

​
Signatures

ST_Difference (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_Difference(ST_GeomFromWKT('POLYGON ((-3 -3, 3 -3, 3 3, -3 3, -3 -3))'), ST_GeomFromWKT('POLYGON ((0 -4, 4 -4, 4 4, 0 4, 0 -4))'))

POLYGON ((0 -3, -3 -3, -3 3, 0 3, 0 -3))