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