[postgis-users] (no subject)

[Pavel Shub]

Hi all,

Please tell me if I'm doing something incorrectly, but I seem to be getting
wrong results for the following bounding box query:

select * from geotest where geom &&
ST_MakeEnvelope(-105.17353271032549,39.798766541338225,-105.07765728967452,39.83016145866177,4326)

Given table with columns: name (varchar), lat (double), lon (double), geom
(geometry). geom having srid 4326 points

A row with lat = 39.830165, lon = -105.130637 is returned. I find this very
peculiar because the latitude is greater than the maxiumum latitude in the
envelope (39.83016145866177). If I then add a 'and lat <=
39.83016145866177' clause, the row is no longer returned.
I noticed this on postgres 9.1 with postgis 1.5 then when testing again got
the same results on postgres 9.2 and postgis 2.0

Is this intended and I missed some documentation somewhere, or is this an
issue?

Thank you,
Pavel Shub
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130202/7c498448/attachment.html>