&&&
上一頁  7.10.1. 邊界框運算子  下一頁

名稱

&&& — 若 A 的 n 維邊界框與 B 的 n 維邊界框相交，則返回 TRUE。

概要

boolean &&&( geometry A , geometry B );

描述

若幾何物件 A 的 n 維邊界框與幾何物件 B 的 n 維邊界框相交，則 &&& 運算子返回 TRUE。

[Note]

此運算元將會利用幾何物件上可能存在的任何索引。

可用性：2.0.0

此方法支援環狀字串和曲線。

此函數支援多面體表面。

此函數支援三角形和三角不規則網路表面 (TIN)。

此函數支援 3D，且不會捨棄 Z 索引。

範例：3D 線字串

SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 AS overlaps_3d,
			            tbl1.column2 && tbl2.column2 AS overlaps_2d
FROM ( VALUES
	(1, 'LINESTRING Z(0 0 1, 3 3 2)'::geometry),
	(2, 'LINESTRING Z(1 2 0, 0 5 -1)'::geometry)) AS tbl1,
( VALUES
	(3, 'LINESTRING Z(1 2 1, 4 6 1)'::geometry)) AS tbl2;

 column1 | column1 | overlaps_3d | overlaps_2d
---------+---------+-------------+-------------
       1 |       3 | t           | t
       2 |       3 | f           | t

範例：3M 線字串

SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 AS overlaps_3zm,
			            tbl1.column2 && tbl2.column2 AS overlaps_2d
FROM ( VALUES
	(1, 'LINESTRING M(0 0 1, 3 3 2)'::geometry),
	(2, 'LINESTRING M(1 2 0, 0 5 -1)'::geometry)) AS tbl1,
( VALUES
	(3, 'LINESTRING M(1 2 1, 4 6 1)'::geometry)) AS tbl2;

 column1 | column1 | overlaps_3zm | overlaps_2d
---------+---------+-------------+-------------
       1 |       3 | t           | t
       2 |       3 | f           | t

另請參閱

&&