Jeff Williams <[EMAIL PROTECTED]> writes: > last_status_change timestamp DEFAULT now()
> What I would like is that whenever the status is changed the > last_status_change timestamp is updated to the current time. For this you use an ON UPDATE trigger; rules are not a good way to solve it. See the documentation about triggers. The first example on this page does it along with a few other things: http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend