Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: When is a record NULL?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "David E. Wheeler" <david(at)kineticode(dot)com>
- Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: When is a record NULL?
- Date: Thu, 23 Jul 2009 19:08:28 -0400
- Message-id: <14776.1248390508@sss.pgh.pa.us> <text/plain>
"David E. Wheeler" <david(at)kineticode(dot)com> writes: > How can a record be neither NULL or NOT NULL? This is per SQL standard. IS NULL is true if *all* the record's fields are null; IS NOT NULL is true if *none* of them are. Yeah, it's a bit dubious, but that's what they said. regards, tom lane
- Follow-Ups:
- Re: When is a record NULL?
- From: David E. Wheeler
- Re: When is a record NULL?
- References:
- When is a record NULL?
- From: David E. Wheeler
- When is a record NULL?
- Prev by Date: Re: join regression failure on cygwin
- 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: