Postgres Pro
Downloads
Home   >   mailing lists

Re: constraint exclusion and nulls in IN (..) clause - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: constraint exclusion and nulls in IN (..) clause
Date
Msg-id CAFjFpRc628=ncXw_y_1tdvVx9M_SKqNoCy_-TEGvmDXib4HcMw@mail.gmail.com
Whole thread Raw
In response to Re: constraint exclusion and nulls in IN (..) clause  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: constraint exclusion and nulls in IN (..) clause  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Re: constraint exclusion and nulls in IN (..) clause  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Feb 1, 2018 at 2:23 PM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
>
> Yeah, the patch in its current form is wrong, because it will give wrong
> answers if the operator being used in a SAOP is non-strict.  I modified
> the patch to consider operator strictness before doing anything with nulls.

That's fine, but I am not sure whether this fits constraint
exclusion's charter. Please add this patch to the next commitfest so
that we can have a better opinion.


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company

pgsql-hackers by date:

Previous
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: Temporary tables prevent autovacuum, leading to XID wraparound
Next
From: Amit Langote
Date:
Subject: Re: constraint exclusion and nulls in IN (..) clause