Re: parameters in functions and overlap with names of columns

Ivan Sergio Borgonovo wrote:
> On Tue, 4 Aug 2009 16:01:58 +0200
> Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
> > 2009/8/4 Ivan Sergio Borgonovo <mail@webthatworks.it>:

> > > 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.
>
> Just to be sure... by qualified names you mean schema qualified name
> or table qualified names in case of columns... right...

In this case I think it also means you can qualify the variable names
with the function name; and/or declare named blocks inside the function,
and qualify the variables with the block name.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support