Re: Touch row ? - Mailing list pgsql-general

From Dustin Sallings
Subject Re: Touch row ?
Date
Msg-id 893597CB-4D87-11D8-9958-000A957659CC@spy.net
Whole thread Raw
In response to Touch row ?  ("NTPT" <ntpt@centrum.cz>)
Responses Article in German iX magazine  (Holger Marzen <holger@marzen.de>)
List pgsql-general
On Jan 23, 2004, at 1:11, NTPT wrote:

> is it possible to add column to database, that will automatically
> contain  date+time (or likely Unix timestamp) when the row was
> touched/changed - ie by INSERT or UPDATE ?

    Yes, a very simple trigger can do this.

--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________


pgsql-general by date:

Previous
From: "NTPT"
Date:
Subject: Touch row ?
Next
From: Mike Mascari
Date:
Subject: Re: Touch row ?