From eebe705848440660153a2826a4695b39400840c8 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 10 Apr 2010 02:48:04 +0000 Subject: [PATCH] start itemizing operators git-svn-id: http://svn.osgeo.org/postgis/trunk@5524 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_wktraster.xml | 173 ++++++++++++++++++++++++++++++++++++ 1 file changed, 173 insertions(+) diff --git a/doc/reference_wktraster.xml b/doc/reference_wktraster.xml index fa13877d8..cc6c820be 100644 --- a/doc/reference_wktraster.xml +++ b/doc/reference_wktraster.xml @@ -1171,4 +1171,177 @@ FROM (SELECT ST_SetRotation(rast,0.1,0.1) As rast + + + Operators + + + && + + Returns TRUE if A's bounding box overlaps B's. + + + + + + boolean && + + + raster + + A + + + + raster + + B + + + + + + + Description + + The && operator returns TRUE if the bounding box of raster A overlaps the bounding box of raster B. + + This operand will make use of any indexes that may be available on the + rasters. + + + + + Examples + + SELECT A.rid As a_rid, B.rid As b_rid, A.rast && B.rast As overlap + FROM dummy_rast AS A CROSS JOIN dummy_rast AS B LIMIT 3; + + a_rid | b_rid | overlap +-------+-------+--------- + 2 | 2 | t + 2 | 3 | f + 2 | 1 | f + + + + + + + &< + + Returns TRUE if A's bounding box is to the left of B's. + + + + + + boolean &< + + + raster + + A + + + + raster + + B + + + + + + + Description + + The &< operator returns TRUE if the bounding box of raster A + overlaps or is to the left of the bounding box of raster B, or more accurately, overlaps or is NOT to the right + of the bounding box of raster B. + + This operand will make use of any indexes that may be available on the + geometries. + + + + Examples + + SELECT A.rid As a_rid, B.rid As b_rid, A.rast &< B.rast As overleft + FROM dummy_rast AS A CROSS JOIN dummy_rast AS B; + +a_rid | b_rid | overleft +------+-------+---------- + 2 | 2 | t + 2 | 3 | f + 2 | 1 | f + 3 | 2 | t + 3 | 3 | t + 3 | 1 | f + 1 | 2 | t + 1 | 3 | t + 1 | 1 | t + + + + + + + &< + + Returns TRUE if A's bounding box is to the right of B's. + + + + + + boolean &> + + + raster + + A + + + + raster + + B + + + + + + + Description + + The &< operator returns TRUE if the bounding box of raster A + overlaps or is to the right of the bounding box of raster B, or more accurately, overlaps or is NOT to the left + of the bounding box of raster B. + + This operand will make use of any indexes that may be available on the + geometries. + + + + Examples + + SELECT A.rid As a_rid, B.rid As b_rid, A.rast &> B.rast As overright + FROM dummy_rast AS A CROSS JOIN dummy_rast AS B; + + a_rid | b_rid | overright +-------+-------+---------- + 2 | 2 | t + 2 | 3 | t + 2 | 1 | t + 3 | 2 | f + 3 | 3 | t + 3 | 1 | f + 1 | 2 | f + 1 | 3 | t + 1 | 1 | t + + + + -- 2.40.0