[postgis-users] Operator precision

Kemal Bayram kemal at cins.co.uk
Mon Feb 23 15:58:34 PST 2009

Hello all,
I'm a using PostGIS working with mainly points testing against 2d bounded
boxes, I recently came across a problem that is driving me nuts whereby:
select makebox2d(makepoint(32.25, 34.9375), makepoint(32.31249, 35)) &&
makepoint(32.3125, 34.996448);
returns false (as expected), where as:
select makebox2d(makepoint(32.25, 34.9375), makepoint(32.312499, 35)) &&
makepoint(32.3125, 34.996448);
returns true.
32.312499 cast as float4 is 32.3125, so I'm assuming that internally single
precision is being used. Is there any way change this behaviour?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090224/ddf3ce76/attachment.html>

More information about the postgis-users mailing list