I was spoiled by the MySQL timestamp field - Mailing list pgsql-general

From Alan T. Miller
Subject I was spoiled by the MySQL timestamp field
Date
Msg-id 003a01c2c2da$a90d10a0$6e01a8c0@webdev
Whole thread Raw
In response to Re: tsearch comments  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: I was spoiled by the MySQL timestamp field
Re: I was spoiled by the MySQL timestamp field
List 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


pgsql-general by date:

Previous
From: Björn Metzdorf
Date:
Subject: Re: tsearch comments
Next
From: Björn Metzdorf
Date:
Subject: Re: I was spoiled by the MySQL timestamp field