Hi all, Is the way in which SQLite handlesNaN and Infinity values as defined by IEEE-754 documented somewhere? I would also be interested to find a discussion of the rationale behind the design decisions.
After some experimenting, it appears that ... * SELECT 1.0 / 0.0 yields NULL (where I would expect to see Inf) * SELECT 1e10000 yields an actual IEEE-754 infinity, and it can be stored in a table * SELECT 1e10000 + 1e10000 yields Infinity, as expected according to IEEE-754. * SELECT 1e10000 - 1e10000 yields NULL, where I would have expected to see NaN in accordance with IEEE-754. Regards, Sidney _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
