Description
The ST_Overlaps function determines whether or not one geometry object
overlaps another geometry object.
Syntax
ST_Overlaps(WritableGeometry geometry1, WritableGeometry geometry2)Parameters
| Parameter | Type | Description |
|---|---|---|
| geometry1 | WritableGeometry | The first instance of a WritableGeometry. |
| geometry2 | WritableGeometry | The second instance of a WritableGeometry. |
Return Values
| Return Type | Description |
|---|---|
| Boolean |
True, if the geometry1 overlaps the
geometry2; otherwise, False.If either
|
Examples
SELECT ST_Overlaps(ST_GeomFromWKT(t1.geometry, 'epsg:4326'), ST_GeomFromWKT(t2.geometry, 'epsg:4326'))
FROM table1 t1, table2 t2;