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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
