Thanks Regina - nice to know it wasn't just my incompetence!.

Good luck tracking down the root cause.


Rgds


Bill



On 4/12/2016 6:53 AM, Regina Obe wrote:

For reference I have ticketed this as:

https://trac.osgeo.org/postgis/ticket/3675

---------- message ----------



Bill,

Never mind. Thanks to Brian Hamlin's nudging on IRC that he sees the issue
too, I was able to replicate it.


I think the reason I missed it in my testing is that it doesn't happen with
the more common cases of:

SELECT e.gid
FROM e1 , e2
WHERE ST_Intersects(e1.geom, e2.geom);

Or where you use constants in ST_MakePoint like your example


But only in case where you have:

SELECT e.gid
FROM e1 , e2
WHERE ST_Intersects(e1.geom, ST_SetSRID(ST_MakePoint(e2.longitude,
e2.latitude),4326)  );


So I'll go ahead and ticket it and try to track down the root cause.  I
suspect it affects all our relation functions.

Thanks for bringing to our attention,

Regina
http://www.postgis.us
http://postgis.net




_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to