- 카테고리:
ST_INTERSECTS¶
Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects intersect (i.e. share any portion of space).
참고
This function does not support using a GeometryCollection or FeatureCollection as input values.
- 참고 항목:
구문¶
ST_INTERSECTS( <geography_expression_1> , <geography_expression_2> )
ST_INTERSECTS( <geometry_expression_1> , <geometry_expression_2> )
인자¶
geography_expression_1
GEOGRAPHY 오브젝트입니다.
geography_expression_2
GEOGRAPHY 오브젝트입니다.
geometry_expression_1
A GEOMETRY object.
geometry_expression_2
A GEOMETRY object.
반환¶
BOOLEAN.
Usage Notes¶
For GEOMETRY objects, the function reports an error if the two input GEOMETRY objects have different SRIDs.
예¶
GEOGRAPHY Examples¶
이는 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¶
이는 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 | +------------------------------------------------------+