<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.5659" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>Hello
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>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:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>select
makebox2d(makepoint(32.25, 34.9375), makepoint(32.31249, 35)) &&
makepoint(32.3125, 34.996448);</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>returns false (as
expected), where as:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>select
makebox2d(makepoint(32.25, 34.9375), makepoint(32.312499, 35)) &&
makepoint(32.3125, 34.996448);</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>returns
true.</SPAN></FONT></DIV></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=031203923-23022009>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?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009>Regards</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=031203923-23022009>Kemal</DIV></SPAN></FONT></FONT></DIV></BODY></HTML>