| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Ken Winter <ken(at)sunward(dot)org> |
| Cc: | "'Bricklen Anderson'" <banderson(at)presinet(dot)com>, "'PostgreSQL pg-sql list'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Arrays in PL/pgSQL routines? |
| Date: | 2005-12-29 18:46:39 |
| Message-ID: | 20051229184639.GA53686@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Dec 29, 2005 at 01:23:28PM -0500, Ken Winter wrote:
> That works. (Odd that the initialization seems to be necessary to make it
> work.) Thanks! Yes, I'm using version 7.4.
7.4.what? Absence of initialization shouldn't cause a syntax error;
at least it doesn't in 7.4.10. However, in 7.4 you do have to
initialize an array before assigning to its elements, else the array
will remain NULL (initialization isn't necessary in the latest 8.x
releases).
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-30 03:00:13 | Re: Does VACUUM reorder tables on clustered indices |
| Previous Message | Tom Lane | 2005-12-29 18:42:18 | Re: Arrays in PL/pgSQL routines? |