Search Postgresql Archives

Re: timestamps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





--On Tuesday, May 25, 2004 20:52:22 -0400 Tom Allison <tallison@tacocat.net> wrote:

How would I specify a field that's to be updated to current_time
everytime the row is created/altered?

Is there some way to put this 'update' property into the table instead of
running some query to do it?
You are looking for a trigger.




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings




-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Attachment: pgp00193.pgp
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux