Re: Rules/Trigges Trade-offs - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Rules/Trigges Trade-offs
Date
Msg-id 200212061631.06077.dev@archonet.com
Whole thread Raw
In response to Rules/Trigges Trade-offs  (Jean-Luc Lachance <jllachan@nsd.ca>)
List 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


pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Rules/Trigges Trade-offs
Next
From: Bruce Momjian
Date:
Subject: Re: Rules/Trigges Trade-offs