X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D3F36475925
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 04:13:17 -0500 (EST)
Received: from ns.i-dea.de (unknown [213.131.254.5])
	by postgresql.org (Postfix) with SMTP id B58C94758E1
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 04:13:16 -0500 (EST)
Received: (qmail 21110 invoked from network); 12 Feb 2003 09:13:18 -0000
Received: from pd9e208d0.dip.t-dialin.net (HELO dj.smaxs-local.de)
	(217.226.8.208) by ns.i-dea.de with SMTP; 12 Feb 2003 09:13:18 -0000
Date: Wed, 12 Feb 2003 10:09:15 +0100
From: Daniel Jaenecke <jaenecke@smaxs.de>
To: pgsql-sql@postgresql.org
Subject: timestamp
Message-Id: <20030212100915.296331a6.jaenecke@smaxs.de>
Organization: smaxs AG
X-Mailer: Sylpheed version 0.8.9 (GTK+ 1.2.10; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/237
X-Sequence-Number: 11635

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