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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Proposal: revert behavior of IS NULL on row types
Дата
Msg-id CAKFQuwaOiJ_6yNq2v2y9kQttN7VEg3exses1SsOzo0zm4G5V1w@mail.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  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers


On Friday, July 22, 2016, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>> "David" == David G Johnston <david.g.johnston@gmail.com> 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.


Yeah, it would need to be targeted there.  I agree with the numbers and the sentiment but it's still allowed and defined behavior which changing invisibly is disconcerting.

David J.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Proposal: revert behavior of IS NULL on row types
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: Re: Unexpected memory usage for repeated inserts within plpgsql function