Home > mailing lists

Re: newbie: update timestamp trigger? - Mailing list pgsql-general

From	Rodrigo De León
Subject	Re: newbie: update timestamp trigger?
Date	October 23, 2007 19:41:57
Msg-id	a55915760710231241s619d66e1iad56f0c2a1117e0b@mail.gmail.com Whole thread Raw
In response to	newbie: update timestamp trigger? (ahnf <interz12@yahoo.com>)
List	pgsql-general

Tree view

On 10/23/07, ahnf <interz12@yahoo.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
tonow() or the current timestamp? 

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

pgsql-general by date:

From: ahnf
Date: 23 October 2007, 19:32:38
Subject: newbie: update timestamp trigger?

From: "Scott Marlowe"
Date: 23 October 2007, 19:43:58
Subject: Re: newbie: update timestamp trigger?

Re: newbie: update timestamp trigger? - Mailing list pgsql-general

Previous

Next