I have a table with 3 fields, id, s_data, and time_stamp. The time_stamp field is set to now() by deault.

The program that uses this table only uses the id and s_data file. I added and use the time_stamp field to delete old records after a certain time.

What I want to do is setup some kind of rule so that whenever a s_data field is updated, that the time_stamp gets update to the current time/date. The program regretab

I'm not really familar with rules, I've only used them in a certain places and very limitedly.

Any help would be greatly appercated.

David Hofmann

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to