Re: float comparison?

[Scott Gifford]

Jerry Swanson <pmysql@stripped> writes:

> Why when I do select from database and try to compare float field with float
> number, I have no results
>
> amount --- type float
>
> select * from price where amount = 3.45 // doesn't work
> 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

----Scott.