Re: Proposal: revert behavior of IS NULL on row types - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Proposal: revert behavior of IS NULL on row types
Date
Msg-id CAKFQuwaOiJ_6yNq2v2y9kQttN7VEg3exses1SsOzo0zm4G5V1w@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: revert behavior of IS NULL on row types  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: Proposal: revert behavior of IS NULL on row types  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List 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 by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Proposal: revert behavior of IS NULL on row types
Next
From: Dilip Kumar
Date:
Subject: Re: Re: Unexpected memory usage for repeated inserts within plpgsql function