From: Ken Winter <ken@sunward.org>
To: 'Bricklen Anderson' <banderson@presinet.com>
Cc: 'PostgreSQL pg-sql list' <pgsql-sql@postgresql.org>
Subject: Re: Arrays in PL/pgSQL routines?
Date: Thu, 29 Dec 2005 13:23:28 -0500
Message-ID: <005a01c60ca4$f79e3bb0$6603a8c0@kenxp> (raw)
In-Reply-To: <43B42273.9030602@presinet.com>
Bricklen ~
That works. (Odd that the initialization seems to be necessary to make it
work.) Thanks! Yes, I'm using version 7.4.
~ Ken
> -----Original Message-----
> From: Bricklen Anderson [mailto:banderson@presinet.com]
> Sent: Thursday, December 29, 2005 12:53 PM
> To: Ken Winter
> Cc: PostgreSQL pg-sql list
> Subject: Re: [SQL] Arrays in PL/pgSQL routines?
>
> Ken Winter wrote:
> > Can arrays be declared in PL/pgSQL routines? If so, how?
> >
> <snip>
> > DECLARE
> >
> try:
> my_array VARCHAR[] := '{}';
>
> not sure if this works in 7.4 though, if that's the version that you are
> using.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ken@sunward.org, banderson@presinet.com
Subject: Re: Arrays in PL/pgSQL routines?
In-Reply-To: <005a01c60ca4$f79e3bb0$6603a8c0@kenxp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox