On 27 Mar 2011, at 2:39am, Patrick Earl wrote: > 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.
Intersting idea. You will need to develop your own C routines to do calculations with decimals. Do you feel they should be implemented at a fixed length or would you want to be able to use decimal strings of arbitrary lengths ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
