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

Stefan Zweig stefanzweig1881 at web.de
Wed Apr 25 07:40:08 PDT 2007


hi,

does anybody have an idea why i get lots results using (about 65000 results in 18313ms)

Select roads."NAME",roads."the_geom"
FROM _g2681 AS roads
WHERE
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°


any help would be appreciated.

regards. stefan
_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192




More information about the postgis-users mailing list