timestamp - Mailing list pgsql-sql

From Daniel Jaenecke
Subject timestamp
Date
Msg-id 20030212100915.296331a6.jaenecke@smaxs.de
Whole thread Raw
Responses Re: timestamp  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-sql
Hi!

I am rather new to PostGreSQL, having mainly used MySQL until now.
MySQL has a column type TIMESTAMP[1] which holds - as expected - a timestamp, but additionally this timestamp is being
updatedautomatically on any UPDATE or INSERT operation.
 

Since this is a quite handy feature to keep track of latest changes I would like to create such a behavior for my
PostGrestables too. But since I have no idea how to do it I would warml welcome any suggestion... :)
 

Thx 
dj

[1]
http://www.mysql.com/doc/en/DATETIME.html


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: How to incorporate exec sql describe select list
Next
From: Christoph Haller
Date:
Subject: Re: PL/Pgsql trigger function problem.