Re: Error when using array variable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Gnanavel S <s(dot)gnanavel(at)gmail(dot)com>, Dongsoo Yoon <dsyoon(at)metasoftworks(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Error when using array variable
Date: 2005-07-23 04:56:26
Message-ID: 18797.1122094586@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> On Fri, Jul 22, 2005 at 03:07:04PM +0530, Gnanavel S wrote:
>> You need to initialse the array, Otherwise any value added to the array will
>> be null.

> This isn't necessary in 8.0, which we can infer is being used because
> of the dollar quotes.

However, plpgsql wasn't fixed to follow that behavior till 8.0.2 or so.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-07-23 09:46:50 Re: Is there a type like a growable array, similar Vector at
Previous Message Michael Fuhr 2005-07-22 23:38:58 Re: Error when using array variable