On Mon, Jul 23, 2007 at 02:05:20PM -0400, Mark Steben wrote: > We have 'table a' which has defined to it an 'after insert or update' > trigger function > > That inserts to 'table b', obviously for every update or insert of table a. > The challenge > > I have now is to update a new date column on 'table a' with a value coming > out of > > Another inhouse written function within the trigger function. But I cannot > use the UPDATE > > statement within the update trigger function for fear of an infinite loop. > > All I need to do is to populate the date field of the row that is currently > being processed by the trigger function. > > Is there a command within plpgsql that can help me with this?
See NEW on http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgp3ePQSKi3pX.pgp
Description: PGP signature