ST_Disjoint( ST_Geometry ) method

Test if a geometry value is spatially disjoint from another value.

Syntax

geometry-expression.ST_Disjoint( ST_Geometry geo2)

geo2 – The other geometry value that is to be compared to the geometry-expression.

BIT Returns 1 if the geometry-expression is spatially disjoint from geo2, otherwise 0.

Example 1 – The following example returns a result with one row for each shape that has no points in common with the specified triangle.

SELECT ShapeID, "Description"
FROM SpatialShapes
WHERE NEW ST_Polygon( 'Polygon((0 0, 5 0, 0 5, 0 0))' ).ST_Disjoint( Shape ) = 1
ORDER BY ShapeID

The example returns the following result set:

ShapeID	Description
1	Point
22	Triangle

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.26