|
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 |
