Re: The semantics of (NULL,NULL) vs NULL

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Ingmar Brouns" <swingi(at)gmail(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: The semantics of (NULL,NULL) vs NULL
Date: 2012-08-02 17:34:07
Message-ID: 501A73BF0200002500049358@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ingmar Brouns <swingi(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-08-02 18:32:33 Re: Need help with SQL query and finding NULL array_agg
Previous Message Peter Geoghegan 2012-08-02 17:15:34 Re: The semantics of (NULL,NULL) vs NULL