2009/8/4 Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>: > Ivan Sergio Borgonovo wrote: >> On Tue, 4 Aug 2009 16:01:58 +0200 >> Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: >> >> > 2009/8/4 Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx>: > >> > > 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. yes Pavel > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
