Automatic mod time?
| От | Steve Lane |
|---|---|
| Тема | Automatic mod time? |
| Дата | |
| Msg-id | 200203120610.g2C6AmSc003801@calypso.fmpro.com обсуждение исходный текст |
| Ответ на | Can't get ODBC from Windows to Linux/Postgres to work ("Jeff Martin" <jeff@dgjc.org>) |
| Ответы |
Re: Automatic mod time?
|
| Список | pgsql-general |
It seems like this should be simple but I haven’t found any obvious pointer in the documents.
I need a timestamp field that’s updated every time a record is touched, to show the last mod date.
I have this working with a trigger just fine. But this means adding a new trigger for each table that needs this.
Is there an easier way?
Thanks,
Steve
=======================================================
Steve Lane
Vice President
Chris Moyer Consulting, Inc.
833 West Chicago Ave Suite 203
Voice: (312) 433-2421 Email: slane@fmpro.com
Fax: (312) 850-3930 Web: http://www.fmpro.com
=======================================================
I need a timestamp field that’s updated every time a record is touched, to show the last mod date.
I have this working with a trigger just fine. But this means adding a new trigger for each table that needs this.
Is there an easier way?
Thanks,
Steve
=======================================================
Steve Lane
Vice President
Chris Moyer Consulting, Inc.
833 West Chicago Ave Suite 203
Voice: (312) 433-2421 Email: slane@fmpro.com
Fax: (312) 850-3930 Web: http://www.fmpro.com
=======================================================
В списке pgsql-general по дате отправления: