Re: [ADMIN] update within trigger function

2007-07-23 Thread Jim C. Nasby
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

[ADMIN] update within trigger function

2007-07-23 Thread Mark Steben
Hello listers, 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 wr