"Paul" <maga...@mail.ru> writes: > Why the condition > SELECT 5 NOT IN (NULL) > returns NULL, but not FALSE (as I thought)?
Because the SQL standard says so.
If you think of NULL as meaning "unknown", it makes some intuitive
sense: it's unknown whether that unknown value is equal to 5.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
