Name

& & & (gidx,gidx) — 退货 TRUE 如果两个n维浮点精度边界框(GIDX)彼此相交。

Synopsis

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

描述

这个 &&& 运算符返回 TRUE 如果两个n维边界框A和B彼此相交,则使用浮点精度。这意味着如果A(或B)是(双精度)框3d,它将在内部转换为浮点精度3D边界框(GIDX)

[Note]

此运算符旨在供Brin索引内部使用,而不是供用户使用。

可用性:2.3.0推出了对数据块范围索引(Brin)的支持。需要PostgreSQL 9.5+。

This method supports Circular Strings and Curves

This function supports Polyhedral surfaces.

This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).

This function supports 3d and will not drop the z-index.

示例

SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&& ST_3DMakeBox(ST_MakePoint(1,1,1), ST_MakePoint(3,3,3)) AS overlaps;

 overlaps
----------
 t
(1 row)

另请参阅

& & & (几何体,gidx) , & & & (gidx,几何体)