tmoore <tmoore(at)ttitech(dot)net> writes:
> Can an after update trigger function do an insert into the the same table ?
Sure. You have to avoid recursively triggering the same trigger, but an
insert wouldn't trigger the update trigger.
regards, tom lane