ST_INTERSECTS
更新时间：2025-10-17
描述
判断几何图形 shape1 是否与几何图形 shape2 相交
:::info 备注 从 PALO 2.1.10 开始支持该函数 :::
语法
SQL
1ST_INTERSECTS( <shape1>, <shape2>)参数
| 参数 | 说明 |
|---|---|
<shape1> |
传入的几何图形，用于判断是否与 shape2 相交 |
<shape2> |
传入的几何图形，用于判断是否与 shape1 相交 |
返回值
返回 1: shape1 图形与图形 shape2 相交
返回 0: shape1 图形与图形 shape2 不相交
举例
SQL
1SELECT ST_Intersects(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_Point(5, 5));
Text
1+--------------------------------------------------------------------------------------+
2| ST_Intersects(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_Point(5, 5)) |
3+--------------------------------------------------------------------------------------+
4| 1 |
5+--------------------------------------------------------------------------------------+
SQL
1SELECT ST_Intersects(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_Point(50, 50));
Text
1+----------------------------------------------------------------------------------------+
2| ST_Intersects(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_Point(50, 50)) |
3+----------------------------------------------------------------------------------------+
4| 0 |
5+----------------------------------------------------------------------------------------+