On Thu, 3 Apr 2003, Rod Taylor wrote:
> > 'K, that makes it workable ... final question (I hope!) ... RULEs vs
> > TRIGGERs? I ended up doing it as a RULE, since I could do it without a
> > function ... but is there a reason why that is a Bad Idea? Or in a case
> > like this, it doesn't really matter?
>
> Rules are per statement, not per row.
>
> An INSERT INTO ... SELECT ... statement will cause a single execution of
> the rule even if you insert several hundred rows.
Ah, okay, definitely not a good thing to use then ... thanks, will finish
what I started with TRIGGERs instead :)