Re: [ADMIN] update Timestamp updated whenever the table is updated

2013-02-12 Thread Kevin Grittner
"Campbell, Lance" wrote: > I would like to have a generic strategy for updating a timestamp > field on some tables whenever the table is updated.  Is there a > recommended strategy for doing this other than via the SQL UPDATE > command? > Example table: > CREATE TABLE test_table > ( >   id integ

[ADMIN] update Timestamp updated whenever the table is updated

2013-02-12 Thread Campbell, Lance
PostgreSQL 9.2.3 I would like to have a generic strategy for updating a timestamp field on some tables whenever the table is updated. Is there a recommended strategy for doing this other than via the SQL UPDATE command? I think I read something about RULES. In the below example I have a table