timestamp

Поиск
Список
Период
Сортировка
От Daniel Jaenecke
Тема timestamp
Дата
Msg-id 20030212094615.5f02ce2b.daniel.jaenecke@smaxs.de
обсуждение исходный текст
Ответы Re: timestamp  (Larry Rosenman <ler@lerctr.org>)
Список 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 по дате отправления:

Предыдущее
От: Wei Weng
Дата:
Сообщение: What's wrong with this identification configuration?
Следующее
От: "Arunachalam Jaisankar"
Дата:
Сообщение: null foreign key column