On 10/23/07, ahnf <interz12@xxxxxxxxx> wrote: > Whenever a row is updated in a table with a timestamp column. How do I write a trigger to set that timestamp column to now() or the current timestamp? You should be able to take a virtual chainsaw to the example on this page and do it: http://www.postgresql.org/docs/8.2/static/plpgsql-trigger.html ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
