Base-10 numbers are frequently used in financial calculations because
of their exact nature. SQLite forces us to store decimal numbers as
text to ensure precision is not lost. Unfortunately, this prevents
even simple operations such as retrieving all rows where an employee's
salary is greater than '100' (coded as a string since decimal types
are stored as strings).
I would like to encourage the developers to consider adding support
for base-10 numbers. This is clearly a very pertinent issue, as even
this month there was another thread regarding decimal support.
Thanks for your consideration.
Patrick Earl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
