Re: Trigger question

Поиск
Список
Период
Сортировка
От Nelio Alves Pereira Filho
Тема Re: Trigger question
Дата
Msg-id 3A22A13B.46E32AF7@ifx.com.br
обсуждение исходный текст
Ответ на Trigger question  (Nelio Alves Pereira Filho <nelio@ifx.com.br>)
Список pgsql-general
> > these values, and the AFTER trigger to do this calculation.
>
> Why don't you just do all the work in the BEFORE trigger?

For instance, If I do an UPDATE inside a function that will be triggered
by an UPDATE, won't it loop forever?

Does PostgreSQL support recursive functions?

Thanks

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

Предыдущее
От: mkennedy@hssinc.com (Matthew Kennedy)
Дата:
Сообщение: strange behaviour
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to keep Postgres from thrashing for a long time using "LIMIT" (or is there a better way?)!