simple auto-updating timestamp ? - Mailing list pgsql-general

From Andreas
Subject simple auto-updating timestamp ?
Date
Msg-id 3FEF5D97.8030706@gmx.net
Whole thread Raw
Responses Re: simple auto-updating timestamp ?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
Hello list,

I suspect, this is a common issue for newbies.
Is there a simple way to have an auto-updating timestamp like mysql has ?

create table something (
   id                int4,
   sometext     text,
   update_ts    timestamp(0),
   primary key (id)
);

Everytime this table gets updated the timestamp should be automatically
refreshed to NOW() ?
I hope someone could point me to an example.


pgsql-general by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: "Keith C. Perry"
Date:
Subject: Re: Is my MySQL Gaining ?