On Sat, Mar 26, 2011 at 10:03 PM, Darren Duncan <dar...@darrenduncan.net> wrote:
> You could store your exact precision numbers as a pair of integers
> representing
> a numerator/denominator ratio and then have math operators that work on these
> pairs like they were one number. You would then know at the end how to move
> the
> radix point since that was kept track of along with the number. -- Darren
> Duncan
If you did this, you wouldn't be able to compare numbers in the
database without resorting to division. If you just specified how
many fixed decimal places there were, you could zero-pad strings if
you only needed to perform comparison operations. Obviously you'd
need to create custom operations, as you suggest, for other math
operators.
If SQLite can't decide on a base-10 format itself, perhaps the answer
lies in enhancing the API to allow for custom type storage and
operators.
Patrick Earl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
