Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Davis
Subject Re: When is a record NULL?
Date
Msg-id 1248388399.25874.12.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to When is a record NULL?  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: When is a record NULL?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
Tree view 
On Thu, 2009-07-23 at 15:19 -0700, David E. Wheeler wrote:
> How can a record be neither NULL or NOT NULL?

You could do:

not ROW(1, NULL) is null and not ROW(1, NULL) is not null

I don't know what the SQL standard says about this.

Regards,Jeff Davis

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: When is a record NULL?
Next
From: Andrew Dunstan
Date:
Subject: Re: join regression failure on cygwin