Re:Postgres 15 improves UNIQUE and NULL
by gsk22 on Monday July 11, 2022 @11:29AM
(#32057431)
Unless you outer join, in which case NULL values pop up out of thin air...
[ Parent
| on HN ]
Good point. I did try to say that whether that's a viable technique would depend on your query (but omitted some verb that should have made it better resemble a sentence in English :)).
But yes, even if no nulls are present in any table, outer join could (or maybe even should) introduce them.