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:[EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
