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 A346D8B9B26 for ; Wed, 9 Feb 2005 14:26:16 +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 00351-07 for ; Wed, 9 Feb 2005 14:26:06 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201]) by svr1.postgresql.org (Postfix) with ESMTP id 485A28B9F90 for ; Wed, 9 Feb 2005 14:26:09 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 36so146941wri for ; Wed, 09 Feb 2005 06:26:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:organization:to:subject:date:user-agent:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id; b=VywXWNAFQaLpWl6/3Qa15tp10CJABNK9+7nxpLbT7fVBeR759LSN7zrqdItxQA9mNq9kO1tpjpe6BD0h4rNT9KP3algB1RgcCDw7UcunbP49R8wtr8z8DaxHFIOYCLMZJ3TB+5k+QkcHY2EJtF6CpwR4WixO7fZX35YS53wzIQA= Received: by 10.54.19.28 with SMTP id 28mr74053wrs; Wed, 09 Feb 2005 06:26:07 -0800 (PST) Received: from aditatu.atlantic.ro ([81.196.16.98]) by smtp.gmail.com with ESMTP id 67sm52366wra.2005.02.09.06.26.06; Wed, 09 Feb 2005 06:26:07 -0800 (PST) From: NosyMan Organization: Noscom To: pgsql-sql@postgresql.org Subject: Re: How to iterate through arrays? Date: Wed, 9 Feb 2005 16:26:41 +0200 User-Agent: KMail/1.7.2 References: <200502091559.08997.nosyman@gmail.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200502091626.42032.nosyman@gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.062 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/121 X-Sequence-Number: 20232 I think the problem is not there. I got the following error: 'ERROR: syntax error at or near "[" at character 1234', the line is: RAISE= =20 NOTICE '% ...',update_query_params[1]; May be someone give a code sample... Thanks Pe data de Mie 09 Feb 2005 16:16, ati scris: > - use TEXT instead of CHAR (what is CHAR without (n) ?) > - inintialize your array with '{}' because it is created as NULL if you = =A0 > just declare it without setting it to an empty array.