Re: newbie: update timestamp trigger?

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: ahnf <interz12(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: newbie: update timestamp trigger?
Date: 2007-10-23 19:41:42
Message-ID: a55915760710231241s619d66e1iad56f0c2a1117e0b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/23/07, ahnf <interz12(at)yahoo(dot)com> 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?

Straight from the horse's mouth:
http://www.postgresql.org/docs/8.2/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-EXAMPLE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-10-23 19:43:31 Re: newbie: update timestamp trigger?
Previous Message ahnf 2007-10-23 19:32:27 newbie: update timestamp trigger?