Thanks, I'll do that.
-----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:52 PM To: LeTortorec, Jean-Louis Cc: '[EMAIL PROTECTED]' Subject: Re: Problem with sum() 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]