TimeStamp for insert/update

From: Zsolt Varga <redax(at)lupus(dot)agria(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: TimeStamp for insert/update
Date: 1998-09-10 13:54:52
Message-ID: 19980910155452.26701@lupus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hi!

I don't know is it possible or not, to make
a filed in any table which contains the insertion/update time
I know
CREATE TABLE ( instime timestamp default now(),.... );
works well for inserts..
but can I do the same for update?

thanks
redax

ps; or it's a 'rules' question?
--
.----------------------------------------------------------.
|Zsolt Varga | tel/fax: +36 36 422811 |
| AgriaComputer LTD | email: redax(at)agria(dot)hu |
| System Administrator | URL: http://www.agria.hu/ |
`----------------------------------------------------------'

Browse pgsql-sql by date

  From Date Subject
Next Message Juan Valero 1998-09-10 17:12:24 Binary variable length string
Previous Message John Palmer 1998-09-10 11:29:09 Thank You