[postgis-users] Operator precision

[Kemal Bayram]

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?
 
Regards
Kemal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090224/ddf3ce76/attachment.html>