| From: | Sevo Stille <sevo(at)ip23(dot)net> |
|---|---|
| To: | Marc Tardif <admin(at)wtbwts(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] automatic timestamp |
| Date: | 2000-02-02 00:05:37 |
| Message-ID: | 389774D1.41F1859D@ip23.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Marc Tardif wrote:
>
> Does postgresql have an automatic timestamp, something built-in which
> could save me from creating an extra date field?
Time travel implied something like that, but that was tied to pg_time,
which is gone now, and, being a log rather than a table, was not
accessible from userland, AFAIR.
However, while you have to create an extra timestamp field for it, it is
trivial to have that field run along without ever maintaining it
actively - give it a DEFAULT CURRENT_TIMESTAMP, and make sure that it is
the last in the table, so that you can insert values().
Sevo
--
Sevo Stille
sevo(at)ip23(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mathprof | 2000-02-02 04:03:15 | Re: [GENERAL] Linking in sin() as a C function |
| Previous Message | Borek.Lupomesky | 2000-02-01 21:53:54 | Re: [GENERAL] Time of last UPDATE or INSERT |