[ .. snip .. snip .. ] > > But....the more important questoin is "Does it make a difference to > your application?" > > Not really. I've talked with the PMs and such about it, and this > doesn't seem to be a problem. I wanted to know how SQLite3 worked in > this department, and this seems to be okay behavior for my application. > The PMs and I were happy to learn about how the strategy worked. > > This peaks my interest though: Is adding that value in the third > decimal place going to ensure that rounding will work appropriately in > all cases?
No it will not work in *ALL* cases. It will fail (do the wrong thing) if it is possible to have a valid input [before rounding] value between [say] 0.0499 and 0.0500. This can occur with valid operations on currency, when calculating tax amounts, or prorating, or percentage discounts, or ... It WILL work, **IF** all input values are REALLY only 2 decimal places, and you just need to handle the imprecision of floating point numbers. [ .. snip .. snip .. ] > Jon [ .. snip .. snip .. ] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
