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