SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
May 19, 2004, 12:11 #1
postgresql default field value manipulation question
Is there a way to have a timestamp field in postgresql update to current date/time whenever there is a change to the record? I want to be able to change the date/time for tracking purposes. If I can do it at the table level that would be great.
Also, was wondering if it's necessary to specify a length for a timestamp field.
-
May 21, 2004, 11:35 #2
- Join Date
- Feb 2004
- Location
- Norway
- Posts
- 39
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You can use a trigger to perform the desired action on an update.
-
May 25, 2004, 05:48 #3
Do you know of any good sites that lists examples are tutorials on working with postgresql triggers?
Originally Posted by Stream
Bookmarks