On Mon, Feb 26, 2001 at 11:53:51AM -0800, Norman J. Clarke wrote:
> Hello,
>
> I am attempting to write a trigger function or rule in pl/pgsql that runs
> on UPDATE to a table named "nodes". From inside this trigger, I would like
> to UPDATE the same "nodes" table. How can I do this without entering into
> an endless loop?
What I did is add a no_update bool to the table and test:
if new.no_update = true then
new.no_update = false;
else
<do your update here>
new.no_update = true;
endif
--
Observe, reason, and experiment.
(if you're too dumb, just pray)