Test if a geometry value is spatially disjoint from another value.
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
ShapeID | Description |
---|---|
1 | Point |
22 | Triangle |
SQL/MM (ISO/IEC 13249-3: 2006) 5.1.26