Postgres Pro
Downloads
Home   >   mailing lists

Re: date stamp on update? - Mailing list pgsql-general

From Tom Lane
Subject Re: date stamp on update?
Date
Msg-id 16214.1227395024@sss.pgh.pa.us
Whole thread Raw
In response to date stamp on update?  ("blackwater dev" <blackwaterdev@gmail.com>)
List pgsql-general
Tree view 
"blackwater dev" <blackwaterdev@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using Postgres to store high volume streams of sensor readings
Next
From: Martin Gainty
Date:
Subject: Re: date stamp on update?