Serena Lien wrote:
Okay, but even if the rounded result does not have a finite binary
representation, shouldn't the displayed (human readable) representation be
at least truncated to the number of decimal places that were requested in
the round function? Not that I am confusing round with truncate, but surely
it is a more acceptable result?
Hm, that is a completely different question. It would mean that more
information is
associated with the rounded result than merely the number (in internal
representation).
I do not know enough about the way SQLite organises these things to
speculate about
that, but it seems like a computational burden to me:
Suppose you have one million records to search for numbers that are then
rounded. Not
only would you need to compute and store the rounded numbers but also
the string
representation (or something to effect that you can get a proper decimal
presentation).
Regards,
Arjen
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
