Date of creation and of change

Поиск
Список
Период
Сортировка
От Andreas Tille
Тема Date of creation and of change
Дата
Msg-id Pine.LNX.4.21.0008231207160.22247-100000@wr-linux02.rki.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: hlefebvre
Дата:
Сообщение: Using SETOF in plpgsql function
Следующее
От: hlefebvre
Дата:
Сообщение: Re: Date of creation and of change