Re: SQL to determine when a row was inserted/updated

Posted in 1997

Richard Stanford — Mon, 7 Jul 1997 15:58:24 -0500 — source: Informix-list mailing list archive (1991-1998)

On Mon, 7 Jul 1997, Roger Tomas wrote: > Since insert triggers cannot affect the triggering table, this > is not possible. (Is there some new version of Informix that > fixes this limitation?) It would be possible to create a set of triggers that updated a scrap table, which also contained triggers that updated the original table. NOTE: This idea is more than a little repugnant, but I don't see any reason why it wouldn't work. Of course, for the /inserts/, why not just have the columns with defaults of CURRENT and USER? -Richard