ST_TOUCHES

描述

判断几何图形 shape1 是否与几何图形 shape2 相接触（即两个几何图形的边界是否相交，但内部不相交）

备注

从 Apache Doris 3.0.6 开始支持该函数

语法

ST_TOUCHES( <shape1>, <shape2>)

参数

参数	说明
<shape1>	传入的几何图形，用于判断是否与 shape2 相接触
<shape2>	传入的几何图形，用于判断是否与 shape1 相接触

返回值

返回 1: shape1 图形与图形 shape2 相接触

返回 0: shape1 图形与图形 shape2 不接触

举例

SELECT ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineStringFromText("LINESTRING (10 5, 15 5)"));

+---------------------------------------------------------------------------------------------------------------------+
| ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineStringFromText("LINESTRING (10 5, 15 5)")) |
+---------------------------------------------------------------------------------------------------------------------+
|                                                                                                                   1 |
+---------------------------------------------------------------------------------------------------------------------+

SELECT ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineFromText("LINESTRING (5 5, 15 5)"));

+--------------------------------------------------------------------------------------------------------------------+
| ST_Touches(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_LineStringFromText("LINESTRING (5 5, 15 5)")) |
+--------------------------------------------------------------------------------------------------------------------+
|                                                                                                                  0 |
+--------------------------------------------------------------------------------------------------------------------+