Re: Rules/Trigges Trade-offs

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Rules/Trigges Trade-offs
Date: 2002-12-06 16:31:06
Message-ID: 200212061631.06077.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-12-06 16:34:37 Re: Rules/Trigges Trade-offs
Previous Message Jean-Luc Lachance 2002-12-06 16:03:47 Rules/Trigges Trade-offs

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-12-06 16:34:37 Re: Rules/Trigges Trade-offs
Previous Message Jean-Luc Lachance 2002-12-06 16:03:47 Rules/Trigges Trade-offs