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
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
On Mon, Jan 16, 2023 at 09:59:38AM -0500, Tom Lane wrote:
> Harmen writes:
> > On Sat, Jan 14, 2023 at 11:23:07AM -0500, Tom Lane wrote:
> >> If you are running a reasonably recent PG version you should be able to
> >> fix that by setting up "extended statistics" on that pair of columns:
>
> >
