Re: How to iterate through arrays?

On Feb 9, 2005, at 9:26 AM, NosyMan wrote:

> 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
> NOTICE '% ...',update_query_params[1];

The problem here is RAISE, NOTICE, etc. can only use simple variables 
in the format string. Try it like:

myTextVar := update_query_params[1];
NOTICE '% ...',myTextVar;


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL