Postgres Pro
Downloads
Home   >   mailing lists

Re: The semantics of (NULL,NULL) vs NULL - Mailing list pgsql-general

From Kevin Grittner
Subject Re: The semantics of (NULL,NULL) vs NULL
Date
Msg-id 501A73BF0200002500049358@gw.wicourts.gov
Whole thread Raw
In response to The semantics of (NULL,NULL) vs NULL  (Ingmar Brouns <swingi@gmail.com>)
List pgsql-general
Tree view 
Ingmar Brouns <swingi@gmail.com> wrote:

> Can anyone explain why:

When it comes to record types, IS NULL is defined to mean "there is
no record or all elements of the record are null".  NOT NULL is
defined to mean that *all elements* of the record are not null.

-Kevin

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: The semantics of (NULL,NULL) vs NULL
Next
From: "David Johnston"
Date:
Subject: Re: Need help with SQL query and finding NULL array_agg