Documentation error
Please see this documentation page:
https://www.postgresql.org/about/featurematrix/detail/392/
It states, "By default, NULL values are not treated as distinct entries."
It should state, "By default, NULL values are treated as distinct entries."
See this blog
<https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null>
.
Best,
Ian
On Wed, Oct 19, 2022 at 10:07 PM Ian R. Campbell <
ian.campbell@thepathcentral.com> wrote:
Please see this documentation page:
https://www.postgresql.org/about/featurematrix/detail/392/It states, "By default, NULL values are not treated as distinct entries."
It should state, "By default, NULL values are treated as distinct entries.
"
Correct. +1. Good catch.
Thanks
Richard
On Thu, Oct 20, 2022 at 11:32 AM Richard Guo <guofenglinux@gmail.com> wrote:
On Wed, Oct 19, 2022 at 10:07 PM Ian R. Campbell <
ian.campbell@thepathcentral.com> wrote:Please see this documentation page:
https://www.postgresql.org/about/featurematrix/detail/392/It states, "By default, NULL values are not treated as distinct entries."
It should state, "By default, NULL values are treated as distinct
entries."Correct. +1. Good catch.
The second sentence in this page is also incorrect.
"Specifying NULLS NOT DISTINCT on unique indexes / constraints will
cause NULL values to be treated distinctly."
It really should be:
"Specifying NULLS NOT DISTINCT on unique indexes / constraints will
cause NULL values to not be treated distinctly."
Thanks
Richard