2009/8/4 Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>:
> I've
>
> create or replace function(...
>
> declare
> col1 varchar(32);
> ...
>
> create table pippo(
> col1 varchar(32),
> ...
>
> Unfortunately I can't schema specify the column to avoid name
> overlap.
>
> Is there another way other than just simply rename the variable?
yes - the most common is an using of prefix '_' for local plpgsql
variables. Other possibility is using qualified names.
Pavel
>
> thanks
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>