As I can see my problem is solved on sqlite 4.
Em 08/03/2013, às 16:35, Israel Lins Albuquerque <israelin...@yahoo.com.br> escreveu: > Thank you guys, and sort for my bad explanation about what I want. I > understand that double problems very well, > I will continue working with round. > > Regards, > Israel Lins > > > Em 08/03/2013, às 16:14, "Marc L. Allen" <mlal...@outsitenetworks.com> > escreveu: > >> Yes.. for what it's worth, I've had this very same problem on MS SQL 2008. >> Comparing floating point values in their raw form is always dangerous. It >> just works so much more often than not that it's easy to forget until you >> get that one number that doesn't work. >> >> The solution for MS SQL was conversion to smallmoney. >> >> -----Original Message----- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin >> Sent: Friday, March 08, 2013 1:37 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] Bug on real operations >> >> >> On 8 Mar 2013, at 6:24pm, Israel Lins Albuquerque <israelin...@yahoo.com.br> >> wrote: >> >>> I don't know how postgres handle this, may be I can check >> >> Postgres has special datatypes used especially to handle problems like this. >> It has both artbitrary precision and monetary datatypes. If you present >> your problem to postgres and let it use floating point numbers it has the >> same problem SQLite has. >> >> However, I used to work with banks and other financial institutions for a >> living and I can assure you that the systems I wrote and used used integer >> datatypes to handle amounts of money. For historical reasons they do >> sometimes multiply by 10,000 instead of 100, but either way all amounts of >> money are stored as integers. This speeds up calculations, reduces storage >> space, and reduces the complexity of testing required. >> >> Just to underline what Richard wrote, this is not a bug in the way SQLite >> handles floating point. The bug is in thinking you can express decimal >> fractions as binary floating point numbers and it is very familiar to >> computer scientists. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> This email and any attachments are only for use by the intended recipient(s) >> and may contain legally privileged, confidential, proprietary or otherwise >> private information. Any unauthorized use, reproduction, dissemination, >> distribution or other disclosure of the contents of this e-mail or its >> attachments is strictly prohibited. If you have received this email in >> error, please notify the sender immediately and delete the original. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
