creating rule like such:
mydb => create rule updtimeset as on update to mytab do update mytab set updtime = current_time ;
causes this:
mydb=> update mytab set updtime = current_time;
ERROR: query rewritten 10 times, may contain cycles
offcourse.
however, it vould be great to have possibility to do something like that.
Yes, i could use triggers, however such solution is not so clear as the rule-method could be...
or do somebody know about ... ?
--
dan peder
dpeder(at)infoset(dot)cz