Re: simple trigger question ...

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 :)