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

From Jeff Davis
Subject Re: When is a record NULL?
Date
Msg-id 1248459644.25874.69.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: When is a record NULL?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Fri, 2009-07-24 at 13:35 -0400, Merlin Moncure wrote:
> I think the following should _not_ return true:
> select (null, null)::somerowtype is null;
> 
> The reasoning being that

It's not at all clear to me that you can "reason" effectively about SQL
logic semantics. Upon which laws are you reasoning? Certainly not 2VL
boolean logic.

The standard is what it is. If it says that some NULLs are red and some
NULLs are blue, then we'd probably support it.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: When is a record NULL?
Next
From: Jeff Davis
Date:
Subject: Re: When is a record NULL?