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.
But yes, even if no nulls are present in any table, outer join could (or maybe even should) introduce them.