Re: postgres_fdw: Handle boolean comparison predicates - Mailing list pgsql-hackers

From Tom Lane
Subject Re: postgres_fdw: Handle boolean comparison predicates
Date
Msg-id 1976748.1629489962@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres_fdw: Handle boolean comparison predicates  (Cary Huang <cary.huang@highgo.ca>)
List pgsql-hackers
Cary Huang <cary.huang@highgo.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



pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: archive status ".ready" files may be created too early
Next
From: Robert Haas
Date:
Subject: Re: Use extended statistics to estimate (Var op Var) clauses