[postgis-users] problem with postgis operators &<|

[Frank Koormann]

Stefan,

* Stefan Zweig <stefanzweig1881 at web.de> [070425 16:41]:
> roads."the_geom" &<| SetSRID(MakePoint(8.1702528, 51.1547968),4326) AND
> roads."the_geom" |&> SetSRID(MakePoint(8.3061512, 51.0931040),4326)
> 
> but not even a single result using (0 result in 15ms)
> 
> Select roads."NAME",roads."the_geom"
> FROM _g2681 AS roads
> WHERE
> roads."the_geom" <<| SetSRID(MakePoint(8.1702528, 51.1547968),4326) =true AND 
> roads."the_geom" |>> SetSRID(MakePoint(8.3061512, 51.0931040),4326) =true
> 
> when i excute the second query i get no result after only 15ms. so to me that seems like postgres/postigs does not even look in the database tables but cancels the query because of an error, but i dont get any error message.
> 
> i am sure that there are geometries(roads) which fullfill the condition to be strictly between 51.09° and 51.15°

"&<|" means somehow below, while "<<|" means _strictly_ below. 
Strictly below the bounding box of a point is simple spoken only a point 
with the same x coordinate or a line with the x coordinate and parallel
to the y axis.

Regards,

        Frank

-- 
Frank Koormann  |  ++49-541-335 08 30  |  http://www.intevation.de/
Intevation GmbH, Osnabrück, DE   |   Amtsgericht Osnabrück, HR B 18998
Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner