timestamp

From: Daniel Jaenecke <jaenecke(at)smaxs(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: timestamp
Date: 2003-02-12 09:09:15
Message-ID: 20030212100915.296331a6.jaenecke@smaxs.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 updated automatically 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 PostGres tables 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-02-12 13:48:58 Re: PL/Pgsql trigger function problem.
Previous Message Christoph Haller 2003-02-12 08:54:17 Re: How to incorporate exec sql describe select list