How to iterate through arrays?

From: NosyMan <nosyman(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to iterate through arrays?
Date: 2005-02-09 13:59:08
Message-ID: 200502091559.08997.nosyman@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-02-09 14:16:33 Re: How to iterate through arrays?
Previous Message Achilleus Mantzios 2005-02-09 13:35:25 Re: parsing a string with a hexadecimal notation