Re: postgres_fdw: Handle boolean comparison predicates

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: postgres_fdw: Handle boolean comparison predicates
Дата
Msg-id
1976748.1629489962@sss.pgh.pa.us
Ответ на
Re: postgres_fdw: Handle boolean comparison predicates (Cary Huang)
Список
Дерево обсуждения
postgres_fdw: Handle boolean comparison predicates Emre Hasegeli <emre@hasegeli.com>
Re: postgres_fdw: Handle boolean comparison predicates Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: postgres_fdw: Handle boolean comparison predicates Emre Hasegeli <emre@hasegeli.com>
Re: postgres_fdw: Handle boolean comparison predicates Daniel Gustafsson <daniel@yesql.se>
Re: postgres_fdw: Handle boolean comparison predicates Daniel Gustafsson <daniel@yesql.se>
Re: postgres_fdw: Handle boolean comparison predicates Ronan Dunklau <ronan.dunklau@aiven.io>
Re: postgres_fdw: Handle boolean comparison predicates Cary Huang <cary.huang@highgo.ca>
Re: postgres_fdw: Handle boolean comparison predicates Tom Lane <tgl@sss.pgh.pa.us> 
Cary Huang  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 по дате отправления
Предыдущее
От: Bossart, Nathan
Дата:
Следующее
От: Robert Haas
Дата:
FAQ