Re: after update trigger ? - Mailing list pgsql-novice

tmoore <tmoore@ttitech.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