postgresql default field value manipulation question

[johnjohn2]

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.

[Stream]

You can use a trigger to perform the desired action on an update.

[johnjohn2]

Do you know of any good sites that lists examples are tutorials on working with postgresql triggers?

You can use a trigger to perform the desired action on an update.