2009/8/4 Ivan Sergio Borgonovo <m...@webthatworks.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
