Re: [ADMIN] on update of table set timestamp

2010-06-22 Thread Kevin Grittner
"Campbell, Lance" 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 UPDA

[ADMIN] on update of table set timestamp

2010-06-22 Thread Campbell, Lance
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 th