"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'sfields 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