Hi Simon, > "Null is a special marker used in Structured Query Language (SQL) to indicate > that a data value does not exist in the database."
To me, this statement does not apply to "NaN", which is a perfectly fine (albeit unusual) floating point value. > If you compare anything with NULL, you will get NULL as a result, even if the > thing you're comparing isn't NULL. This depends on how you compare: SELECT NULL = NULL; --> NULL SELECT NULL IS NULL; --> 1. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users