>There are many cases where people are doing calculations or using >numbers expecting them to retain all digits. This would allow the BCD >type to be used for that if they really need it.
Currency conversions (rarely exact!) or tax (or margin) calculations come to mind as very common uses requiring a bit more than plus and minus operations with extended integers support and expected to be available at the SQL level along with correct rounding. It's true that embedding anything like full GNU GMP would make "lite" a joke, but a decent subset and something like decimal(n,p) type would certainly be beneficial for a large number of SLite users. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users