Re: Documentation discrepancy UNIQUE NULLS NOT DISTINCT

2023-01-19 Thread David G. Johnston
On Thu, Jan 19, 2023 at 3:41 PM Adrian Klaver 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 cau

Documentation discrepancy UNIQUE NULLS NOT DISTINCT

2023-01-19 Thread Adrian Klaver
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://ww