On Thu, Jan 19, 2023 at 3:41 PM Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

>  From here:
>
> https://www.postgresql.org/about/featurematrix/detail/392/
>
> UNIQUE NULLS NOT DISTINCT
>
> By default, NULL values are not treated as distinct entries. Specifying
> NULLS NOT DISTINCT on unique indexes / constraints will cause NULL
> values to be treated distinctly.
>
>
>  From here:
>
> https://www.postgresql.org/docs/current/sql-createindex.html
>
> NULLS DISTINCT
> NULLS NOT DISTINCT
>
>      Specifies whether for a unique index, null values should be
> considered distinct (not equal). The default is that they are distinct,
> so that a unique index could contain multiple null values in a column.
>
> and here:
>
> https://www.postgresql.org/docs/current/sql-createtable.html
>
> For the purpose of a unique constraint, null values are not considered
> equal, unless NULLS NOT DISTINCT is specified.
>
>
I think saying that NULLs are distinct by default is the better way to
present this.  The documentation disagrees on the verbiage but both state
the same truth; the feature matrix page needs to be fixed.

David J.

Reply via email to