X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 5122B9DC843
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Dec 2005 13:52:40 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 66530-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Dec 2005 13:52:38 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from presinet.com (presinet.com [209.53.156.1])
	by postgresql.org (Postfix) with ESMTP id 740379DC817
	for <pgsql-sql@postgresql.org>; Thu, 29 Dec 2005 13:52:37 -0400 (AST)
Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft
	SMTPSVC(6.0.3790.1830); Thu, 29 Dec 2005 09:49:36 -0800
Message-ID: <43B42273.9030602@presinet.com>
Date: Thu, 29 Dec 2005 09:52:51 -0800
From: Bricklen Anderson <banderson@presinet.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Ken Winter <ken@sunward.org>
CC: PostgreSQL pg-sql list <pgsql-sql@postgresql.org>
Subject: Re: Arrays in PL/pgSQL routines?
References: <005101c60c9f$cfb5f660$6603a8c0@kenxp>
In-Reply-To: <005101c60c9f$cfb5f660$6603a8c0@kenxp>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 29 Dec 2005 17:49:36.0406 (UTC)
	FILETIME=[3BCA6B60:01C60CA0]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200512/242
X-Sequence-Number: 23784

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.