Re: date stamp on update?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "blackwater dev" <blackwaterdev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: date stamp on update?
Date: 2008-11-22 23:03:44
Message-ID: 16214.1227395024@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"blackwater dev" <blackwaterdev(at)gmail(dot)com> writes:
> Is there a datatype in postgres that will automatically update the date when
> the row is updated?

No, and it's conceptually impossible to make that happen at the datatype
level. Use a trigger.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2008-11-22 23:18:05 Re: date stamp on update?
Previous Message Tom Lane 2008-11-22 23:02:39 Re: Using Postgres to store high volume streams of sensor readings