With most types you deal with in SQL and more specifically PostgreSQL, when you use a condition
such as something IS NULL
and it returns false
, you can be assured that
something IS NOT NULL
would return true
. This is not the case
with composite types.