Ivan Sergio Borgonovo <[email protected]> writes:
> Pavel Stehule <[email protected]> wrote:
>> 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...
Right. The plpgsql parser is (just barely) smart enough to not try
to substitute a local variable name for the second part of a qualified
name "a.b". So you could write "tab.col1" in your queries.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
