Date of creation and of change

From: Andreas Tille <tillea(at)rki(dot)de>
To: PostgreSQL SQL <pgsql-sql(at)hub(dot)org>
Subject: Date of creation and of change
Date: 2000-08-23 10:10:38
Message-ID: Pine.LNX.4.21.0008231207160.22247-100000@wr-linux02.rki.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

could someone enlighten a fairly beginner how to define columns
of a table with the following features:

CreateDate DEFAULT value should store current date and time
ChangeDate DEFAULT value at creation as above and a Trigger
function which stores data end time of any change
to the data set

I hope someone has this quite usual feature handy or at least a
pointer where this is described.

Thank you very much

Andreas.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message hlefebvre 2000-08-23 10:39:39 Re: Date of creation and of change
Previous Message hlefebvre 2000-08-23 10:07:36 Using SETOF in plpgsql function