Re: syntax error during function call - Mailing list pgsql-general

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
rod@iol.ie