On Tue, 18 Apr 2023 at 05:01, Corey Huinker <corey.huin...@gmail.com> wrote: > I'm ok with the wording as-is, but perhaps we can phrase it as "distinct" vs > "not equal", thus leaning into the syntax a bit: > > By default, null values in a unique column are considered distinct, allowing > multiple nulls in the column. > > > or maybe > > By default, null values in a unique column are considered > <literal>DISTINCT</literal>, allowing multiple nulls in the column.>
I acknowledge your input, but I didn't think either of these was an improvement over what David suggested. I understand that many people will know that "SELECT DISTINCT" and "WHERE x IS NOT DISTINCT FROM y" means treat NULLs equally, but I don't think we should expect the reader here to know that's what we're talking about. In any case, we're talking about existing wording here, not something David is adding. David
