Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: When is a record NULL?
- From: Jeff Davis <pgsql(at)j-davis(dot)com>
- To: Merlin Moncure <mmoncure(at)gmail(dot)com>
- Cc: "David E. Wheeler" <david(at)kineticode(dot)com>, Brendan Jurd <direvus(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: When is a record NULL?
- Date: Fri, 24 Jul 2009 11:20:44 -0700
- Message-id: <1248459644.25874.69.camel@monkey-cat.sm.truviso.com> <text/plain>
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
- References:
- When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- From: Tom Lane
- Re: When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- From: Tom Lane
- Re: When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- From: Jeff Davis
- Re: When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- From: Brendan Jurd
- Re: When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- From: Merlin Moncure
- When is a record NULL?
- Prev by Date: Re: When is a record NULL?
- Next by Date: Re: When is a record NULL?
- Previous by thread: Re: When is a record NULL?
- Next by thread: Re: When is a record NULL?
- Indexes: