> '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.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc