> 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.
Much as I like MySQL, it can sometimes be a little *too* helpful.
> 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?
When you create the table do something like:
CREATE TABLE foo (
bar timestamp DEFAULT now(),
...
);
You can of course do this with any column-type and value. See the
SQL-reference for details.
- Richard Huxton