Date of creation and of change - Mailing list pgsql-sql

From Andreas Tille
Subject Date of creation and of change
Date
Msg-id Pine.LNX.4.21.0008231207160.22247-100000@wr-linux02.rki.de
Whole thread Raw
List 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.




pgsql-sql by date:

Previous
From: hlefebvre
Date:
Subject: Using SETOF in plpgsql function
Next
From: hlefebvre
Date:
Subject: Re: Date of creation and of change