Re: comparing NEW and OLD (any good this way?) - Mailing list pgsql-general

From Greg Stark
Subject Re: comparing NEW and OLD (any good this way?)
Date
Msg-id 407d949e0908131553p1e877b7s76436b09561d26c2@mail.gmail.com
Whole thread Raw
In response to Re: comparing NEW and OLD (any good this way?)  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: comparing NEW and OLD (any good this way?)
Re: comparing NEW and OLD (any good this way?)
List pgsql-general
On Thu, Aug 13, 2009 at 11:44 PM, Daniel Verite<daniel@manitou-mail.org> wrote:
>> In other discussions about similar issues I've said that the expression:
>>
>>   ROW(NULL,NULL) IS DISTINCT FROM NULL
>>
>> should evaluate to FALSE.  I still think this is correct and generally
>> useful behavior.
>
> I see no reason to disagree with this. Besides, the fact that
> ROW(NULL,NULL) IS DISTINCT FROM NULL evaluates to true
> while ROW(NULL,NULL) IS NULL also evaluates to true
> looks quite puzzling to me.


Why is this thread still going on? What does the spec say we should be
doing and are we violating it in any of these cases?


--
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: comparing NEW and OLD (any good this way?)
Next
From: Emanuel Calvo Franco
Date:
Subject: Re: plperl function