Name

& & & (几何体,gidx) — 退货 TRUE 如果几何体的(缓存)n维边界框与n维浮点精度边界框(GIDX)相交。

Synopsis

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

描述

这个 &&& 运算符返回 TRUE 如果缓存的几何A的n维边界框与n维边界框B相交,则使用浮点精度。这意味着如果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_MakePoint(1,1,1) &&& ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) AS overlaps;

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

另请参阅

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