"Campbell, Lance" <lance(at)illinois(dot)edu> wrote:
> I want to add a timestamp column to some of my important table
> such that whenever an SQL "update" command is executed on the
> table the "updated_timestamp" timestamp column would be set with
> "now()".
I would write one function which I would bind as a BEFORE UPDATE
trigger to all the tables with the updated_timestamp column. You
don't need to write a separate function for each table.
-Kevin