[postgis-devel] overlaps left

Kevin Neufeld kneufeld at refractions.net
Wed Jan 21 15:00:18 PST 2009


OK, I think what this should be saying is that &< returns true if it overlaps or is NOT to the right of ...

Kevin Neufeld wrote:
> Typo.. that was &<
> 
> Kevin Neufeld wrote:
>> The docs said that &> returned true if the bounding boxes overlap OR 
>> is to the left of ...
>>
>> That doesn't seem to be the case:
>> SELECT tbl1.column1, tbl2.column1,
>>   tbl1.column2 && tbl2.column2 AS overlaps,
>>   tbl1.column2 &< tbl2.column2 AS overlapsleft
>> FROM
>>   ( VALUES
>>     (1, 'LINESTRING( 1 2, 4 6 )'::geometry)) AS tbl1,
>>   ( VALUES
>>     (2, 'LINESTRING( 0 0, 3 3 )'::geometry)) AS tbl2;
>>
>>  column1 | column1 | overlaps | overlapsleft
>> ---------+---------+----------+--------------
>>        1 |       2 | t        | f
>> (1 row)
>>
>>
>> -- Kevin
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel



More information about the postgis-devel mailing list