Name
&<| — Returns TRUE if A's bounding box overlaps or is below B's.
Synopsis
boolean &<|( geometry A , geometry B );
Descripción
The &<| operator returns TRUE if the bounding box of geometry A overlaps or is below of the bounding box of geometry B, or more accurately, overlaps or is NOT above the bounding box of geometry B.
This method supports Circular Strings and Curves.
This function supports Polyhedral surfaces.
![[Note]](../images/note.png)
|
|
|
This operand will make use of any indexes that may be available on the geometries. |
Ejemplos
SELECT tbl1.column1, tbl2.column1, tbl1.column2 &<| tbl2.column2 AS overbelow
FROM
( VALUES
(1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,
( VALUES
(2, 'LINESTRING(0 0, 3 3)'::geometry),
(3, 'LINESTRING(0 1, 0 5)'::geometry),
(4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;
column1 | column1 | overbelow
---------+---------+-----------
1 | 2 | f
1 | 3 | t
1 | 4 | t
(3 rows)