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.
Continue reading "Composite data types why IS NOT NULL is not the same as NOT IS NULL"
