Обсуждение: on update of table set timestamp
PostgreSQL 8.4
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()”. Is there a way to do this? I know I could go through and change my SQL all over the place to update a column “updated_timestamp” with “now()” but it would be faster if there was some way to set a constraint and/or default value on the field. Is this possible. I don’t really want to do store procedures.
Thanks,
Lance Campbell
Software Architect/DBA/Project Manager
Web Services at Public Affairs
217-333-0382
"Campbell, Lance" <lance@illinois.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