Re: postgres_fdw: Handle boolean comparison predicates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cary Huang <cary(dot)huang(at)highgo(dot)ca>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Emre Hasegeli <emre(at)hasegeli(dot)com>
Subject: Re: postgres_fdw: Handle boolean comparison predicates
Date: 2021-08-20 20:06:02
Message-ID: 1976748.1629489962@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Cary Huang <cary(dot)huang(at)highgo(dot)ca> writes:
> I also agree with Ashutosh that the "IS NOT TRUE" case can be simplified to just "IS FALSE". it's simpler to understand.

Uh ... surely that's just wrong?

regression=# select null is not true;
?column?
----------
t
(1 row)

regression=# select null is false;
?column?
----------
f
(1 row)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2021-08-20 20:06:52 Re: Use extended statistics to estimate (Var op Var) clauses
Previous Message Bossart, Nathan 2021-08-20 19:41:28 Re: archive status ".ready" files may be created too early