Raymond, I tried your suggestion but the result is the same when "whoami" is declared at the top of the function and assigned inside the loop.
Thanks for the suggestion anyway. -----Original Message----- From: Raymond O'Donnell [mailto:[email protected]] Sent: Wednesday, January 27, 2010 11:00 AM To: Aycock, Jeff R. Cc: [email protected] Subject: Re: [GENERAL] syntax error during function call On 27/01/2010 15:40, Aycock, Jeff R. wrote: > BEGIN > > FOR r IN SELECT * FROM schema_1.snapshot_table > > LOOP > > > > DECLARE whoami text := r; I could be wrong, but I don't think that the DECLARE inside the loop is correct. I think you have to declare "whoami" with the rest of your variables in the DECLARE block at the top of the function, and then you can assign to it inside the loop. Ray. -- Raymond O'Donnell :: Galway :: Ireland [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
