I was spoiled by the MySQL timestamp field
Alan T. Miller <amiller@hollywood101.com>
From: "Alan T. Miller" <amiller@hollywood101.com>
To: <pgsql-general@postgresql.org>
Date: 2003-01-23T12:26:31Z
Lists: pgsql-general
As someone who is just getting started with PostygreSQL from years working with MySQL, it appears that the timestamp data type does not behave in the way it did with MySQL. I got used to just defining a column as a timestamp and letting the database throw the latest time stamp in there whenever a row was updated. Is there anything simular in PosgreSQL? How can I accomplish something simular inside the database, or am I stuck populating the field in some manner as in the following example update blah blah blah timestamp = NOW() Thanks, Alan