ST_TOUCHES
更新时间：2025-10-17
描述
判断几何图形 shape1 是否与几何图形 shape2 相接触（即两个几何图形的边界是否相交，但内部不相交）
:::info 备注 从 PALO 2.1.10 开始支持该函数 :::
语法
SQL
1ST_TOUCHES( <shape1>, <shape2>)参数
| 参数 | 说明 |
|---|---|
<shape1> |
传入的几何图形，用于判断是否与 shape2 相接触 |
<shape2> |
传入的几何图形，用于判断是否与 shape1 相接触 |
返回值
返回 1: shape1 图形与图形 shape2 相接触
返回 0: shape1 图形与图形 shape2 不接触
举例
SQL
1SELECT ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineStringFromText("LINESTRING (10 5, 15 5)"));
Text
1+---------------------------------------------------------------------------------------------------------------------+
2| ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineStringFromText("LINESTRING (10 5, 15 5)")) |
3+---------------------------------------------------------------------------------------------------------------------+
4| 1 |
5+---------------------------------------------------------------------------------------------------------------------+
SQL
1SELECT ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineFromText("LINESTRING (5 5, 15 5)"));
Text
1+--------------------------------------------------------------------------------------------------------------------+
2| ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineStringFromText("LINESTRING (5 5, 15 5)")) |
3+--------------------------------------------------------------------------------------------------------------------+
4| 0 |
5+--------------------------------------------------------------------------------------------------------------------+