Disjoint
DISJOINT(g1 Geometry, g2 Geometry)
Alias: ST_DISJOINT
Returns 1 if g1 and g2 have no shared points; returns 0 otherwise. Returns the opposite of INTERSECTS.
Result type: integer
Examples:
SELECT DISJOINT(POLYFROMTEXT('POLYGON((0 10, 10 10, 8 0, 2 0, 0 10))'), POLYFROMTEXT('POLYGON((10 13, 20 13, 18 3, 12 3, 10 13))'));
---------------
col1
---------------
1
---------------
SELECT DISJOINT(POLYFROMTEXT('POLYGON((0 10, 10 10, 8 0, 2 0, 0 10))'), POLYFROMTEXT('POLYGON((8 13, 18 13, 16 3, 10 3, 8 13))'));
--------------
col1
--------------
0
--------------
Last modified date: 01/30/2023