Skip site navigation (1) Skip section navigation (2)

Re: Assigning null to an array element in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eugene Chow <gene(at)paragonam(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Assigning null to an array element in plpgsql
Date: 2005-11-16 15:17:33
Message-ID: 5859.1132154253@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Eugene Chow <gene(at)paragonam(dot)com> writes:
> I believe this is a bug. The following function returns 'foo' instead  
> of null:

NULLs in arrays aren't supported; the system interprets an attempt to
store a NULL into an array element as a no-op.  Perhaps it should have
raised an error instead, but it's been that way for a long time and
we're not likely to change the behavior of existing releases.

(I'm actually right in the middle of adding support for null array
elements, but it won't appear until 8.2.)

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-11-16 16:26:49
Subject: Re: Double sequence increase on single insert with RULE on targeted table
Previous:From: Sarunas KrisciukaitisDate: 2005-11-16 08:31:10
Subject: Re: Double sequence increase on single insert with RULE on

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group