Re: Touch row ?

Поиск
Список
Период
Сортировка
Искать
От
Dustin Sallings
Тема
Re: Touch row ?
Дата
Msg-id
893597CB-4D87-11D8-9958-000A957659CC@spy.net
Ответ на
Список
Дерево обсуждения
Upcoming events Bruce Momjian <pgman@candle.pha.pa.us>
Re: Upcoming events Joseph Shraibman <jks@selectacast.net>
Re: Upcoming events Bruce Momjian <pgman@candle.pha.pa.us>

On Jan 23, 2004, at 1:11, NTPT wrote:

> is it possible to add column to database, that will automatically 
> contain  date+time (or likely Unix timestamp) when the row was 
> touched/changed - ie by INSERT or UPDATE ?

	Yes, a very simple trigger can do this.

--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings 
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________

В списке pgsql-general по дате отправления
От: NTPT
Дата:
Сообщение: Touch row ?
От: Mike Mascari
Дата:
Сообщение: Re: Touch row ?
FAQ