>>

>>
Anterior	7.10.1. Bounding Box Operators	Siguiente

Nombre

>> — Returns TRUE if A's bounding box is strictly to the right of B's.

Sinopsis

boolean >>( geometry A , geometry B );

Descripción

The >> operator returns TRUE if the bounding box of geometry A is strictly to the right of the bounding box of geometry B.


	This operand will make use of any indexes that may be available on the geometries.

Ejemplos

Code

SELECT tbl1.column1, tbl2.column1, tbl1.column2 
>
> tbl2.column2 AS right
FROM
  ( VALUES
    (1, 'LINESTRING (2 3,5 6)'::geometry)) AS tbl1,
  ( VALUES
    (2, 'LINESTRING (1 4,1 7)'::geometry),
    (3, 'LINESTRING (6 1,6 5)'::geometry),
    (4, 'LINESTRING (0 0,4 3)'::geometry)) AS tbl2;

Output

 column1 | column1 | right
---------+---------+-------
       1 |       2 | t
       1 |       3 | f
       1 |       4 | f
(3 rows)

Figure

Ver también

<<, |>>, <<|