timestamp

Поиск
Список
Период
Сортировка
От Daniel Jaenecke
Тема timestamp
Дата
Msg-id 20030212100915.296331a6.jaenecke@smaxs.de
обсуждение исходный текст
Ответы Re: timestamp  (Dmitry Tkach <dmitry@openratings.com>)
Список pgsql-sql
Hi!

I am rather new to PostGreSQL, having mainly used MySQL until now.
MySQL has a column type TIMESTAMP[1] which holds - as expected - a timestamp, but additionally this timestamp is being
updatedautomatically on any UPDATE or INSERT operation.
 

Since this is a quite handy feature to keep track of latest changes I would like to create such a behavior for my
PostGrestables too. But since I have no idea how to do it I would warml welcome any suggestion... :)
 

Thx 
dj

[1]
http://www.mysql.com/doc/en/DATETIME.html


В списке pgsql-sql по дате отправления:

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: How to incorporate exec sql describe select list
Следующее
От: Christoph Haller
Дата:
Сообщение: Re: PL/Pgsql trigger function problem.