Re: Problem with sum()

Thu, 03 Apr 2003 13:51:45 -0800

Because neither 0.7 nor 0.1 have an exact binary floating point reprsentation.
Use Decimal type instead.

LeTortorec, Jean-Louis wrote:

Hello every one,

I have a simple table, with a "float" field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.

When I do a "select sum(quantity) from mytable", I got 0.7999998956919
instead of 0.8.

Does any body know why?

Thanks.

Jean-Louis






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to