Re: Proposal: revert behavior of IS NULL on row types

Поиск
Список
Период
Сортировка
Искать
От
Andrew Gierth
Тема
Re: Proposal: revert behavior of IS NULL on row types
Дата
Msg-id
87eg6lqjhn.fsf@news-spur.riddles.org.uk
Ответ на
Re: Proposal: revert behavior of IS NULL on row types (David G. Johnston)
Список
Дерево обсуждения
Proposal: revert behavior of IS NULL on row types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Proposal: revert behavior of IS NULL on row types Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Proposal: revert behavior of IS NULL on row types Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: revert behavior of IS NULL on row types "David G. Johnston" <david.g.johnston@gmail.com>
Re: Proposal: revert behavior of IS NULL on row types Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: revert behavior of IS NULL on row types Thomas Munro <thomas.munro@enterprisedb.com>
Re: Proposal: revert behavior of IS NULL on row types Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Proposal: revert behavior of IS NULL on row types Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: revert behavior of IS NULL on row types Kevin Grittner <kgrittn@gmail.com>
Re: Proposal: revert behavior of IS NULL on row types "David G. Johnston" <david.g.johnston@gmail.com>
Re: Proposal: revert behavior of IS NULL on row types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Proposal: revert behavior of IS NULL on row types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Proposal: revert behavior of IS NULL on row types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Proposal: revert behavior of IS NULL on row types "David G. Johnston" <david.g.johnston@gmail.com>
Re: Proposal: revert behavior of IS NULL on row types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Proposal: revert behavior of IS NULL on row types "David G. Johnston" <david.g.johnston@gmail.com>
Re: Proposal: revert behavior of IS NULL on row types Jim Nasby <Jim.Nasby@BlueTreble.com> 
>>>>> "David" == David G Johnston  writes:
>> Prohibiting IS NOT NULL is not on the cards; it's very widely used.
David> ​Yet changing how it behaves, invisibly, is?

Did you mean prohibiting it only for composite-type args? It's obviously
widely used for non-composite args.

I would expect that >95% of cases where someone has written (x IS NOT
NULL) for x being a composite type, it's actually a bug and that NOT (x
IS NULL) was intended.

-- 
Andrew (irc:RhodiumToad)
В списке pgsql-hackers по дате отправления
Предыдущее
От: David G. Johnston
Дата:
Следующее
От: David G. Johnston
Дата:
FAQ