| From: | Dustin Sallings <dustin(at)spy(dot)net> |
|---|---|
| To: | "NTPT" <ntpt(at)centrum(dot)cz> |
| Cc: | "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Touch row ? |
| Date: | 2004-01-23 09:35:52 |
| Message-ID: | 893597CB-4D87-11D8-9958-000A957659CC@spy.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general |
On Jan 23, 2004, at 1:11, NTPT wrote:
> is it possible to add column to database, that will automatically
> contain date+time (or likely Unix timestamp) when the row was
> touched/changed - ie by INSERT or UPDATE ?
Yes, a very simple trigger can do this.
--
SPY My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2004-01-23 09:35:57 | Re: Touch row ? |
| Previous Message | NTPT | 2004-01-23 09:11:15 | Touch row ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2004-01-23 09:35:57 | Re: Touch row ? |
| Previous Message | NTPT | 2004-01-23 09:11:15 | Touch row ? |