- Kategorien:
ST_INTERSECTS¶
Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects intersect (i.e. share any portion of space).
Bemerkung
This function does not support using a GeometryCollection or FeatureCollection as input values.
- Siehe auch:
Syntax¶
ST_INTERSECTS( <geography_expression_1> , <geography_expression_2> )
ST_INTERSECTS( <geometry_expression_1> , <geometry_expression_2> )
Argumente¶
geography_expression_1
Ein GEOGRAPHY-Objekt.
geography_expression_2
Ein GEOGRAPHY-Objekt.
geometry_expression_1
A GEOMETRY object.
geometry_expression_2
A GEOMETRY object.
Rückgabewerte¶
Ein BOOLEAN-Wert.
Usage Notes¶
For GEOMETRY objects, the function reports an error if the two input GEOMETRY objects have different SRIDs.
Beispiele¶
GEOGRAPHY Examples¶
Das folgende Beispiel zeigt eine einfache Verwendung der Funktion ST_INTERSECTS:
SELECT ST_INTERSECTS( 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_INTERSECTS( | | 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))') | | ) | |---------------------------------------------------------| | True | +---------------------------------------------------------+
GEOMETRY Examples¶
Das folgende Beispiel zeigt eine einfache Verwendung der Funktion ST_INTERSECTS:
SELECT ST_INTERSECTS( TO_GEOMETRY('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))'), TO_GEOMETRY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))') );+------------------------------------------------------+ | ST_INTERSECTS( | | TO_GEOMETRY('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))'), | | TO_GEOMETRY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))') | | ) | |------------------------------------------------------| | True | +------------------------------------------------------+