Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> writes: > Pavel Stehule <pavel.stehule@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
