Обсуждение: 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.
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,NULLvalues are not treated as distinct entries."It should state, "By default,NULLvalues are treated as distinct entries."
Correct. +1. Good catch.
Thanks
Richard
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,NULLvalues are not treated as distinct entries."It should state, "By default,NULLvalues 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
"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