Re: WIP: Allow SQL-language functions to reference parameters by parameter name

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Дата
Msg-id 28551.1301108505@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WIP: Allow SQL-language functions to reference parameters by parameter name  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mar 25, 2011, at 9:22 PM, Joshua Berkus <josh@agliodbs.com> wrote:
>> Also, I don't understand why this would be a dump/reload issue if $1 and $2 continue to work.

> Because an identifier that previously referred unambiguously to a column might now be ambiguous, if there is a
parameterwith the same name.
 

Yes, a function that previously worked might now throw error, if we make
ambiguous names be errors.  But this is *not* a failure that would occur
during dump/reload.  You'd have to actually run the function.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: WIP: Allow SQL-language functions to reference parameters by parameter name