Triggers with DO functionality

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Triggers with DO functionality
Дата
Msg-id CAA-aLv4m=f9cc1zcUzM49pE8+2NpytUDraTgfBmkTOkMN_wO2w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Triggers with DO functionality  ("David E. Wheeler" <david@justatheory.com>)
Re: Triggers with DO functionality  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Hi,

This may have already been discussed before, but I can't find any
mention of it.  Would it be desirable to add support for triggers that
contain their own anonymous functions (i.e. DO)?

So instead of

CREATE TRIGGER...
EXECUTE PROCEDURE functioname();

you'd have:

CREATE TRIGGER...
DO $$
...
$$;

The purpose being to only have a single statement to set up the
trigger rather than setting up a separate trigger function which will
unlikely be re-used by other triggers... or is this of dubious
benefit?

-- 
Thom


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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Command Triggers
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Command Triggers