- Catégories :
ST_DISJOINT¶
Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects are disjoint (i.e. do not share any portion of space). ST_DISJOINT is equivalent to NOT ST_INTERSECTS(expr1, expr2).
Note
This function does not support using a GeometryCollection or FeatureCollection as input values.
- Voir aussi :
Syntaxe¶
ST_DISJOINT( <geography_expression_1> , <geography_expression_2> )
ST_DISJOINT( <geometry_expression_1> , <geometry_expression_2> )
Arguments¶
geography_expression_1
Un objet GEOGRAPHY.
geography_expression_2
Un objet GEOGRAPHY.
geometry_expression_1
A GEOMETRY object.
geometry_expression_2
A GEOMETRY object.
Renvoie¶
BOOLEAN.
Usage Notes¶
For GEOMETRY objects, the function reports an error if the two input GEOMETRY objects have different SRIDs.
Exemples¶
GEOGRAPHY Examples¶
Les exemples suivants utilisent la fonction ST_DISJOINT pour déterminer si deux objets géospatiaux sont disjoints :
-- These two polygons are disjoint and do not intersect. SELECT ST_DISJOINT( TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), TO_GEOGRAPHY('POLYGON((3 3, 5 3, 5 5, 3 5, 3 3))') ); +---------------------------------------------------------+ | ST_DISJOINT( | | TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), | | TO_GEOGRAPHY('POLYGON((3 3, 5 3, 5 5, 3 5, 3 3))') | | ) | |---------------------------------------------------------| | True | +---------------------------------------------------------+-- These two polygons intersect and are not disjoint. SELECT ST_DISJOINT( TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), TO_GEOGRAPHY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))') ); +---------------------------------------------------------+ | ST_DISJOINT( | | TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), | | TO_GEOGRAPHY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))') | | ) | |---------------------------------------------------------| | False | +---------------------------------------------------------+