I was spoiled by the MySQL timestamp field

Поиск
Список
Период
Сортировка
От Alan T. Miller
Тема I was spoiled by the MySQL timestamp field
Дата
Msg-id 003a01c2c2da$a90d10a0$6e01a8c0@webdev
обсуждение исходный текст
Ответ на Re: tsearch comments  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: I was spoiled by the MySQL timestamp field  (dev@archonet.com)
Re: I was spoiled by the MySQL timestamp field  (will trillich <will@serensoft.com>)
Список pgsql-general
As someone who is just getting started with PostygreSQL from years working
with MySQL, it appears that the timestamp data type does not behave in the
way it did with MySQL. I got used to just defining a column as a timestamp
and letting the database throw the latest time stamp in there whenever a row
was updated. Is there anything simular in PosgreSQL? How can I accomplish
something simular inside the database, or am I stuck populating the field in
some manner as in the following example

update blah blah blah timestamp = NOW()

Thanks,

Alan


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

Предыдущее
От: Björn Metzdorf
Дата:
Сообщение: Re: tsearch comments
Следующее
От: Björn Metzdorf
Дата:
Сообщение: Re: I was spoiled by the MySQL timestamp field