On 2019/06/12 6:04 PM, Simon Slavin wrote:
On 12 Jun 2019, at 4:35pm, R Smith <ryansmit...@gmail.com> wrote:
(maybe a sort of CAST target or collation rather than a column "Type")
That's an interesting idea. With a REAL value you get the same things when you
print -0.0 and +0.0. But if you CAST it to a new type of I754 then apply
printf to that, you could get different text from the two values.
Indeed - although James makes an important point, the -0.0 of IEEE754
isn't a useful feature, it's an artifact - a happenstance of an imposed
rule, not an answer to a mathematical concept needing to be
computerized. The CAST / Collation idea is still useful though for those
specifically interested in the real IEEE754 bit representation (as
Jonathan and Keith pointed out), which can even be improved to contain
the rest of the IEEE754 features as you've mentioned in the
conversion/text representation.
I now wonder if this is possible to implement as a simple User collation.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
