Re: Trigger question

From: Nelio Alves Pereira Filho <nelio(at)ifx(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger question
Date: 2000-11-27 18:00:27
Message-ID: 3A22A13B.46E32AF7@ifx.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-27 18:17:42 Re: How to keep Postgres from thrashing for a long time using "LIMIT" (or is there a better way?)!
Previous Message Matthew Kennedy 2000-11-27 17:57:11 strange behaviour