I had a query (for Postgres and Informix) with a
NOT IN clause containing a subquery that in some cases returned
NULL values, causing that clause (and the entire query) to fail to return anything.
What's the best way to understand this? I thought of
NULL as something without a value, and therefore wasn't expecting the query to fail, but obviously that's not the correct way to think of