X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 822B48B9F92
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  9 Feb 2005 13:58:10 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 97589-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  9 Feb 2005 13:57:52 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199])
	by svr1.postgresql.org (Postfix) with ESMTP id 0B52B8B9F83
	for <pgsql-sql@postgresql.org>; Wed,  9 Feb 2005 13:57:55 +0000 (GMT)
Received: by wproxy.gmail.com with SMTP id 71so1280852wra
	for <pgsql-sql@postgresql.org>; Wed, 09 Feb 2005 05:57:55 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:from:to:subject:date:user-agent:organization:mime-version:content-type:content-transfer-encoding:content-disposition:message-id;
	b=mrvnL4XMUIpyFOe/KSdQcp7davfHaYHXw56CfRU1fGQDP39MawXL8WJR4p1cjmZWlfOs8l1X+NgYpTjynqxVtBEVns9gRtJ+RpabvqbCeyvVK3V22YxwIAfcpnEX8bM1AEontEHC+D2uGk23GQjIFF7Z34WUkQiwUfNVFeg2iVQ=
Received: by 10.54.18.63 with SMTP id 63mr68843wrr;
	Wed, 09 Feb 2005 05:57:54 -0800 (PST)
Received: from aditatu.atlantic.ro ([81.196.16.98])
	by smtp.gmail.com with ESMTP id 66sm37852wra.2005.02.09.05.57.53;
	Wed, 09 Feb 2005 05:57:54 -0800 (PST)
From: NosyMan <nosyman@gmail.com>
To: pgsql-sql@postgresql.org
Subject: How to iterate through arrays?
Date: Wed, 9 Feb 2005 15:59:08 +0200
User-Agent: KMail/1.7.2
Organization: Noscom
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200502091559.08997.nosyman@gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.074 tagged_above=0 required=5
	tests=FORGED_RCVD_HELO, RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200502/119
X-Sequence-Number: 20230

Hi there,

I'm trying to iterate through arrays in PL/PGSQL:
....
	DECLARE
		update_query CHAR;
		update_query_params CHAR ARRAY[6];
	BEGIN
			update_query_params[1]:='some text';		
			
			RAISE NOTICE 'Testing element %', update_query_params[1];
	END
.....


It does not 'compile'... :-(. Can you tell me what is the problem?

Thanks,
Nosy