Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE
Дата
Msg-id Y3wX09yd0TKKJ1Wj@paquier.xyz
обсуждение исходный текст
Ответ на Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE  (vignesh C <vignesh21@gmail.com>)
Ответы Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE  (vignesh C <vignesh21@gmail.com>)
Список pgsql-hackers
On Fri, Oct 28, 2022 at 05:34:37PM +0530, vignesh C wrote:
> Those also should be handled, attached v2 version includes the changes
> for the same.

The basic options supported by PROCEDURE are a subset of ROUTINE with a
difference of COST, IMMUTABLE, [NOT] LEAKPROOF, ROWS, STABLE
and VOLATILE.

The basic options supported by ROUTINE are a subset of FUNCTION with a
difference of { CALLED | RETURNS NULL } ON NULL INPUT, STRICT and
SUPPORT.  Is it worth refactoring a bit with common lists?

+       "RESET", "RETURNS NULL ON NULL INPUT ", "ROWS",
Extra space after INPUT here, that's easy to miss.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Error-safe user functions
Следующее
От: Nathan Bossart
Дата:
Сообщение: wake up logical workers after ALTER SUBSCRIPTION