Re: [SQL] RULE for mtime recording

2005-04-22 Thread Christoph Haller
Enrico Weigelt wrote: > > Hi folks, > > I'd like to write an update rule, which touches the a mtime field > (=current_timestamp) on normal update - when the mtime field isnt > explicitly set. If the update query explictly sets an mtime value, > this value has to be let through. > > my tables loo

[SQL] RULE for mtime recording

2005-04-21 Thread Enrico Weigelt
Hi folks, I'd like to write an update rule, which touches the a mtime field (=current_timestamp) on normal update - when the mtime field isnt explicitly set. If the update query explictly sets an mtime value, this value has to be let through. my tables look like: -- base class CREATE T