| From: | Daniel Jaenecke <daniel(dot)jaenecke(at)smaxs(dot)de> |
|---|---|
| To: | PostgreSQL sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | timestamp |
| Date: | 2003-02-12 08:46:15 |
| Message-ID: | 20030212094615.5f02ce2b.daniel.jaenecke@smaxs.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Haller | 2003-02-12 08:54:17 | Re: How to incorporate exec sql describe select list |
| Previous Message | Alessandro Pedrotti | 2003-02-12 07:49:11 | R: adding not null constraints on columns |