parameters in functions and overlap with names of columns

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: parameters in functions and overlap with names of columns
Date: 2009-08-04 12:20:00
Message-ID: 20090804142000.3dae759e@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Taylor 2009-08-04 12:37:34 Does derby have an embedded Mode like Derby ?
Previous Message Alban Hertroys 2009-08-04 11:59:11 Re: Refer to another database