Re: update within trigger function

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                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)