News for hackers. Stuff that matters.
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...
Re:Postgres 15 improves UNIQUE and NULL by almog on Monday July 11, 2022 @03:27PM (#32060606)
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.