Re: Proposal TODO Item: SQL-language reference parameters by name

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal TODO Item: SQL-language reference parameters by name
Дата
Msg-id 8094.1193801804@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal TODO Item: SQL-language reference parameters by name  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Список pgsql-hackers
"Gevik Babakhani" <pgdev@xs4all.nl> writes:
>> I think the most likely implementation would involve adding hooks
>> in the parser at places where "unknown column" errors are about to
>> be thrown, so that a function language could check for a match to
>> one of its variable names only after the query-exposed names are
>> checked.

> Would this be the right path to follow?

> Assuming we are allowed to include parameter names into ParseState, we can
> match the "non existing" colnames against the list of parameter
> names when transformColumnRef (or someware safe in that path).

You are assuming that the function language isn't interested in taking
some extra action when a reference to a parameter is recognized.  This
is demonstrably false for plpgsql, for one --- it wants to build a list
of just which variables it will have to pass into each SQL command.
A hook function can take care of that, a passive data structure can't.
        regards, tom lane


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: UTF-8 for SGML docs?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UTF-8 for SGML docs?