&&&

📄字数 488

👁️阅读量 加载中...

功能描述

如果 A 的 N 维边界框与 B 的 N 维边界框相交，则&&&操作符返回TRUE。

语法格式

BOOLEAN &&&( GEOMETRY A , GEOMETRY B );

参数说明

• A：目标 GEOMETRY 对象。
• B：目标 GEOMETRY 对象。

函数返回类型

BOOLEAN 类型

使用说明

1. 该操作符将利用几何上可能可用的任何索引。
2. 该操作符支持圆形字符串和曲线。
3. 该操作符支持多面体曲面。
4. 该操作符支持三角形和不规则三角网面 (TIN)。
5. 该操作符支持 3d 并且不会丢失 z-index。

示例

SQL> SELECT tbl1.c1 AS t1_c1, tbl2.c1 AS t2_c1, tbl1.goem &&& tbl2.goem AS OVERLAPS_3d,tbl1.goem && tbl2.goem AS overlaps_2d
     FROM (
     SELECT 1 AS c1, 'LINESTRING Z(0 0 1, 3 3 2)'::GEOMETRY AS goem UNION ALL
     SELECT 2 AS c1, 'LINESTRING Z(1 2 0, 0 5 -1)'::GEOMETRY AS goem ) AS tbl1,
     (SELECT 3 AS c1, 'LINESTRING Z(1 2 1, 4 6 1)'::GEOMETRY AS goem) AS tbl2;

+-------+-------+-------------+-------------+
| T1_C1 | T2_C1 | OVERLAPS_3D | OVERLAPS_2D |
+-------+-------+-------------+-------------+
| 1     | 3     | T           | T           |
| 2     | 3     | F           | T           |
+-------+-------+-------------+-------------+

(2 rows)