[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