On Jan 5, 2011, at 4:25 AM, Jean-Christophe Deschamps wrote: > Richard, > >> Use floating point for the purpose for which it was created: scientific >> calculations. If you need to know your bank balance to 17 significant >> figures, use integers. Store the values as cents instead of dollar and do >> the conversion in your application. > > I do exactly that in my own applications as much as I can, but integers > don't always solve the problem, even for common financial transactions: > tax or interest rates, currency conversions and the like often force > transient use of FP. > > Of course I'm not advocating including some version of a decimal FP > library into SQLite. I was in fact just saying we still are in the > infancy of IT. The good news is that there is plenty of room for > innovation left to next generation's engineers.
Thats why years ago IBM 1400 series did all their arith with long strings of bcd numbers for finance. Additionally IBM7000 series and PDP9's could add .33333333 to .666666 and get 1.0. Maybe PDP10's and IBM 360s but I can't remember. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
