On Mon, Jun 6, 2011 at 5:57 AM, Simon Slavin <slav...@bigfraud.org> wrote: > No, it's in the standard. Unfortunately you have to pay to receive the > standards document, but in the draft standard at > > http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt > > see the top of page 7: > > "null value (null): A special value, or mark, that is used to > indicate the absence of any data value."
But since infinity is not "absence of data", nor is NaN... It'd be OK for NaN to map to NULL, but not for infinity, since there is a distinction between positive and negative infinity, and that distinction is valuable. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
