| From: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Rules/Trigges Trade-offs |
| Date: | 2002-12-06 17:30:15 |
| Message-ID: | 3DF0DEA7.14D89064@nsd.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Thanks for the info.
Do you mean that if an update affects more than one row I should use
triggers because the rules will be executed only once?
JLL
Richard Huxton wrote:
>
> On Friday 06 Dec 2002 4:03 pm, Jean-Luc Lachance wrote:
> > Hi all!
> >
> > Is there a guideline on the use of rules compared to triggers when both
> > can be use to achieve the same result?
>
> If I can use rules I do. Rules rewrite the query so are processed once,
> whereas triggers get processed for every row.
> --
> Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-12-06 17:41:07 | Re: Rules/Trigges Trade-offs |
| Previous Message | dialist | 2002-12-06 17:19:31 | tedia2sql Announce |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-12-06 17:41:07 | Re: Rules/Trigges Trade-offs |
| Previous Message | Bruce Momjian | 2002-12-06 16:34:37 | Re: Rules/Trigges Trade-offs |