newbie: update timestamp trigger?

From: ahnf <interz12(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: newbie: update timestamp trigger?
Date: 2007-10-23 19:32:27
Message-ID: 646873.85229.qm@web36612.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo De León 2007-10-23 19:41:42 Re: newbie: update timestamp trigger?
Previous Message Josi Perez 2007-10-23 19:10:59 Service pgsql-8.1 failed to start