On 5 Jun 2011, at 6:10pm, Sidney Cadot wrote: >> Note that according to SQL semantics, 'NULL' means 'I don't know'. > > I am not quite sure what you are saying. I am pretty sure that NULL is > not defined so informally ... :)
I expressed it in a short way, but I think it's a fair summary. Take a look here: <http://en.wikipedia.org/wiki/Null_(SQL)> "Null is a special marker used in Structured Query Language (SQL) to indicate that a data value does not exist in the database." >> So every value of all types matches with it. > > I don't understand what "matches with" means in this context, sorry. If you compare anything with NULL, you will get NULL as a result, even if the thing you're comparing isn't NULL. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
