From: | David J N Begley <d(dot)begley(at)uws(dot)edu(dot)au> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Composite types and NULL within PL/pgSQL |
Date: | 2006-05-06 16:28:29 |
Message-ID: | Pine.LNX.4.61.0605070219150.18931@viper.uws.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 6 May 2006, Tom Lane wrote:
> In general the distinction between a true null composite value and a
> row-of-nulls is not made very cleanly in PG. I'd be inclined to
> deprecate the former --- you cannot enter such a thing as a row of a
> table, for example, and that is the basic property that any rowtype
> ought to have no?
True - though obviously composite types are not always used as whole rows as
in the first example/test from my original message (also in the PostgreSQL
documentation describing composite types); in that case the composite type
was a single column and could indeed accept a true null.
> In short, don't do that.
Could section 8.11 of the docs be updated to include such a warning?
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Konzack | 2006-05-06 18:58:05 | tablespace and backup |
Previous Message | Will Reese | 2006-05-06 16:04:04 | Re: EnterpriseDB |