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
Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
In response to
pgsql-admin by date
|Next:||From: Peter Koczan||Date: 2007-07-24 00:35:46|
|Subject: Re: "_" in a serach pattern|
|Previous:||From: De Leeuw Guy||Date: 2007-07-23 21:06:47|
|Subject: trigger bugs ? and suggestions|