| From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
|---|---|
| To: | Rod Taylor <rbt(at)rbt(dot)ca> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: simple trigger question ... |
| Date: | 2003-04-03 23:00:26 |
| Message-ID: | 20030403185938.D7340@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Myrta | 2003-04-03 23:02:09 | Re: can i make this sql query more efficiant? |
| Previous Message | Franco Bruno Borghesi | 2003-04-03 22:15:15 | Re: can i make this sql query more efficiant? |