Re: UNIQUE null treatment option - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: UNIQUE null treatment option
Date
Msg-id CAH2-Wzm+LwPHX=pB7i6PoTrQi=C_WbF-6yNYqrotX5mSc7s4nQ@mail.gmail.com
Whole thread Raw
In response to Re: UNIQUE null treatment option  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On Thu, Jan 13, 2022 at 10:36 AM Peter Geoghegan <pg@bowt.ie> wrote:
> I wonder if the logic for setting BTScanInsertData.anynullkeys inside
> _bt_mkscankey() is the place to put your test for
> rel->rd_index->indnullsnotdistinct -- not inside _bt_doinsert(). That
> would probably necessitate renaming anynullkeys, but that's okay. This
> feels more natural to me because a NULL key column in a NULLS NOT
> DISTINCT unique constraint is very similar to a NULL non-key column in
> an INCLUDE index, as far as our requirements go -- and so both cases
> should probably be dealt with at the same point.

Correction: I meant to write "...a NULL key column in a NULLS DISTINCT
unique constraint is very similar...".

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: UNIQUE null treatment option
Next
From: Andres Freund
Date:
Subject: Re: Adding CI to our tree