Search Postgresql Archives

Re: syntax error during function call

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:rod@xxxxxx] 
Sent: Wednesday, January 27, 2010 11:00 AM
To: Aycock, Jeff R.
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  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
rod@xxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux