Re: plpgsql and qualified variable names

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql and qualified variable names
Дата
Msg-id 25734.1184454634@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql and qualified variable names  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-hackers
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> ISTM supporting "somefunc.ambiguous" just gives us another way to
> reference the parameter, and there still isn't any way to refer the column.

Sure.  All this will do is let us remove a noted incompatibility with
Oracle, which seems worth doing if it's a one-line change that doesn't
break anything.

Further down the road, we could imagine some option in plpgsql that
prevents substitution of variables *unless* they are qualified with
the appropriate block name --- in which case we'd better make sure
there is a way to qualify function parameter names.  So this might
be a necessary component of a solution that tightens up the
substitution behavior, but it's not the solution by itself.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: plpgsql FOR loop doesn't guard against strange step values
Следующее
От: "Affan Salman"
Дата:
Сообщение: Re: plpgsql and qualified variable names