Today I’ve found out a flavor of PostgreSQL when checking if a composite type column is not null. There are different ways of checking for not null columns:
- NOTNULL
- IS NOT NULL
- NOT ISNULL
For primitive values any of the above works, while for the composite types there is a particularity.
Given a table of users with a deleted column of a composite type action, and some users marked as deleted, I need all users that are deleted. Continue reading PostgreSQL NOTNULL vs IS NOT NULL vs NOT ISNULL