Re: When is a record NULL? - Mailing list pgsql-hackers

From Greg Stark
Subject Re: When is a record NULL?
Date
Msg-id 407d949e0907241329x3d495e65yecb57e82af4e86fd@mail.gmail.com
Whole thread Raw
In response to Re: When is a record NULL?  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: When is a record NULL?
List pgsql-hackers
On Fri, Jul 24, 2009 at 7:49 PM, Merlin Moncure<mmoncure@gmail.com> wrote:
> Still, why:
>
> *) is select null::foo is distinct from (null, null)::foo; true?
> (null should not be distinct from null)
>
> *) does (null, null) allow STRICT functions to execute?
>
> *) is (null, null)::text not null?

These are all good questions. Are you interested in checking what the
spec says should happen in these cases?


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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Proposal: More portable way to support 64bit platforms
Next
From: Martijn van Oosterhout
Date:
Subject: Re: SE-PostgreSQL Specifications