Name

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

Synopsis

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

描述

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

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

另请参阅

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