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

From Emre Hasegeli
Subject Re: constraint exclusion and nulls in IN (..) clause
Date
Msg-id CAE2gYzz3FebhWH0Wg9Abo6b6PR0aKyTrmaF7sHrqCe_xBDRuig@mail.gmail.com
Whole thread Raw
In response to Re: constraint exclusion and nulls in IN (..) clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Yeah, that's there.  We need both operators to be strict, I think;
otherwise we can't really assume anything about what they'd return
for NULL inputs.  But if they are, we have NULL => NULL which is
valid for all proof cases.

I understand.  I don’t see any problems in this case.


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: pgbench - add \if support
Next
From: David Steele
Date:
Subject: Re: Re: new function for tsquery creartion