Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

date stamp on update? - Mailing list pgsql-general

From blackwater dev
Subject date stamp on update?
Date
Msg-id 34a9824e0811221434i262d47b0r45019921e24b4a9b@mail.gmail.com
Whole thread Raw
Responses Re: date stamp on update?
Re: date stamp on update?
Re: date stamp on update?
List pgsql-general
Is there a datatype in postgres that will automatically update the date when the row is updated?  I know I can do a timestamp and set the default to now() but once the row is inserted, and then edited, I want the column updated without editing my application code or adding a trigger.  Is this possible with Postgres?

Thanks!

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Using Postgres to store high volume streams of sensor readings
Next
From: Gregory Stark
Date:
Subject: Re: Postgres mail list traffic over time