I was spoiled by the MySQL timestamp field

From: "Alan T(dot) Miller" <amiller(at)hollywood101(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: I was spoiled by the MySQL timestamp field
Date: 2003-01-23 12:26:31
Message-ID: 003a01c2c2da$a90d10a0$6e01a8c0@webdev
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Björn Metzdorf 2003-01-23 12:32:09 Re: I was spoiled by the MySQL timestamp field
Previous Message Björn Metzdorf 2003-01-23 11:49:41 Re: tsearch comments