Re: pl/pgsql feature request: shorthand for argument and local variable references

Поиск
Список
Период
Сортировка
От Joel Jacobson
Тема Re: pl/pgsql feature request: shorthand for argument and local variable references
Дата
Msg-id d4ad5fd2-2337-4744-a43c-73644d9b66ef@www.fastmail.com
обсуждение исходный текст
Ответ на Re: pl/pgsql feature request: shorthand for argument and local variable references  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: pl/pgsql feature request: shorthand for argument and local variable references  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers
On Sun, Mar 28, 2021, at 15:12, Pavel Stehule wrote:
Maybe I don't understand your proposal well, I am sorry. Creating your own language should not be hard, but in this case the plpgsql is not well extendable. The important structures are private. You can do it, but you should do a full copy of plpgsql. I don't think so you can reuse handler's routines - it is not prepared for it. Unfortunately, the handler expects only function oid and arguments, and there is not a possibility how to pass any options (if I know).

Sorry, let me clarify what I mean.

I mean something along the lines of adding a new nullable column to "pg_language", maybe "lanroutinelabel"?
All other columns (lanispl, lanpltrusted, lanplcallfoid, laninline, lanvalidator) would reuse the same values as plpgsql.

/Joel

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Idea: Avoid JOINs by using path expressions to follow FKs
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: [PATCH] Enhancements to pg_stat_statements contrib extension