On Tue, 18 Apr 2023 at 05:01, Corey Huinker <corey.huinker@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
syntaxa 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