Re: Why can't I have a "language sql" anonymous block?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Why can't I have a "language sql" anonymous block?
Дата
Msg-id CAKFQuwa0XH7bQxycTSw8FiBbwcsEKxOSKZt=q-XemfR0uyjyZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why can't I have a "language sql" anonymous block?  (Bryn Llewellyn <bryn@yugabyte.com>)
Ответы Re: Why can't I have a "language sql" anonymous block?  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general
On Monday, December 13, 2021, Bryn Llewellyn <bryn@yugabyte.com> wrote:

There must be a reason to prefer a “language sql” procedure over a “language plpgsql” procedure—otherwise the former wouldn’t be supported.

I would say that is true for functions.  I wouldn’t assume that for procedures - it’s probable that because sql already worked for functions we got that feature for free when implementing procedures.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Properly handling aggregate in nested function call
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Why can't I have a "language sql" anonymous block?