Re: float comparison?

[Hassan Schroeder]

Scott Gifford wrote:

>>select * from price where amount = 3.45 // doesn't work

> Floating point numbers are very rarely equal, because of small
> rounding errors that happen all the time.  Probably the actual number
> in the database is something like '3.44000000000000001'.
> 
> Try something like this:
> 
>    select * from price where amount > 3.44 and amount <= 3.46

Or maybe             ... where ROUND(amount,2) = 3.45;

-- 
Hassan Schroeder ----------------------------- hassan@stripped
Webtuitive Design ===  ([phone]   === http://webtuitive.com

                          dream.  code.