Try the CREATE RULE blah AS ON INSERT TO foo DO INSTEAD form of rule
creation (note the use of the keyword INSTEAD)..
> Would someone be kind enough to write a rule for me which does
> this? All the rules I've tried to write create infinite loops
> (since the RULE is defined as ON INSERT, and its action is
> doing an INSERT to the same table, which triggers the rule
> again).
- Andrew