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


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to