"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
In response to
pgsql-hackers by date
|Next:||From: David E. Wheeler||Date: 2009-07-23 23:17:00|
|Subject: Re: When is a record NULL? |
|Previous:||From: Tom Lane||Date: 2009-07-23 23:06:07|
|Subject: Re: join regression failure on cygwin |