Re: [SQL] defaults on updates

2003-11-01 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > Basically, I have 5 fields, one being a PK (SERIAL), 3 with information, and > the last one a timestamp field that will show the last time the register was > modified (tmodif which has a DEFAULT CURRENT_TIMESTAMP). > Now, eveytime someone modifys any,

[SQL] defaults on updates

2003-11-01 Thread Martin Marques
Hi, I'm trying to make some sort of function, rule, trigger, or what ever that would be capable of modifing my table on an update. Basically, I have 5 fields, one being a PK (SERIAL), 3 with information, and the last one a timestamp field that will show the last time the register was modified (