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

Поиск
Список
Период
Сортировка
От Gevik Babakhani
Тема Re: Proposal TODO Item: SQL-language reference parameters by name
Дата
Msg-id 004301c81b45$97ad75c0$0a01a8c0@gevmus
обсуждение исходный текст
Ответ на Proposal TODO Item: SQL-language reference parameters by name  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Ответы Re: Proposal TODO Item: SQL-language reference parameters by name  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Thank you Tom.

> 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). I Think this 
way
we at least can parse a function when CreateFunction is called.

If the above is correct to implement then the check should have low 
precedence in order to not break
the current functionality (first colnames, then $n params and then parameter 
names)

Regards,
Gevik.








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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: URGENT HELP about 'duration' stats
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [COMMITTERS] pgsql: simple script to pull together a very small (<500k) tar file