Hi Simon,
> Jay is talking about SQL. SQL /does/ use NULL for 'unknown'.
Well yes, it does, but my entire point is that floating point NaN is
quite different from "Unknown".
SQLite sort-of unifies NaN and NULL (although this isn't documented).
However, this is not an SQL choice -- it is an implementation choice.
PostgreSQL and MySQL, for example, handle NaN values as floating point
values, quite distinctly from NULL values, e.g. in Postgres:
# SELECT CAST('NaN' AS DOUBLE PRECISION);
float8
--------
NaN
(1 row)
> And the OP was trying to match values with NULL.
Actually, no, I was asking how SQlite behaves with respect to IEEE-754
floating point.
Sidney
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
