Test if a geometry value is spatially disjoint from another value.
geometry-expression.ST_Disjoint(geo2)
Name | Type | Description |
---|---|---|
geo2 |
ST_Geometry |
The other geometry value that is to be compared to the geometry-expression. |
Returns 1 if the geometry-expression is spatially disjoint from geo2, otherwise 0.
Tests if a geometry value is spatially disjoint from another value. Two geometries are disjoint if their intersection is empty. In other words, they are disjoint if there is no point anywhere in geometry-expression that is also in geo2."
geometry-expression.ST_Disjoint( geo2 ) = 1 is equivalent to geometry-expression.ST_Intersects( geo2 ) = 0.
5.1.26
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 |