"Paul" <magamos@xxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
