Re: parameters in functions and overlap with names of columns - Mailing list pgsql-general

From Pavel Stehule
Subject Re: parameters in functions and overlap with names of columns
Date
Msg-id 162867790908040701j1f69dc66w84f48c10b4f15c88@mail.gmail.com
Whole thread Raw
In response to parameters in functions and overlap with names of columns  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: parameters in functions and overlap with names of columns
List pgsql-general
2009/8/4 Ivan Sergio Borgonovo <mail@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
>

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?
Next
From: Paul Taylor
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?