From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: parameters in functions and overlap with names of columns |
Date: | 2009-08-04 14:50:33 |
Message-ID: | 20090804145033.GD6494@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ivan Sergio Borgonovo wrote:
> On Tue, 4 Aug 2009 16:01:58 +0200
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
> > 2009/8/4 Ivan Sergio Borgonovo <mail(at)webthatworks(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Taylor | 2009-08-04 14:56:05 | Re: Does derby have an embedded Mode like Derby ? |
Previous Message | Abraham, Danny | 2009-08-04 14:48:36 | InitDB 8.3.7 fails on Windows - Failed system call was MapViewOfFileEx |