Re: Touch row ?
| От | Chris Boget |
|---|---|
| Тема | Re: Touch row ? |
| Дата | |
| Msg-id | 01b101c3e1c8$d927aa30$8c01a8c0@ENTROPY обсуждение исходный текст |
| Ответ на | Re: Upcoming events (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: Touch row ?
Re: Touch row ? Re: Touch row ? |
| Список | pgsql-general |
> > 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. Wouldn't just setting the default value of the field to be NOW() accomplish the same thing? Or can you not default the value of a timestamp field? Chris
В списке pgsql-general по дате отправления: