Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C74404766CB for ; Fri, 6 Dec 2002 11:36:11 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 11743476677 for ; Fri, 6 Dec 2002 11:34:38 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id gB6GYbt02565; Fri, 6 Dec 2002 11:34:37 -0500 (EST) From: Bruce Momjian Message-Id: <200212061634.gB6GYbt02565@candle.pha.pa.us> Subject: Re: Rules/Trigges Trade-offs In-Reply-To: <3DF0CA63.84F4D48@nsd.ca> To: Jean-Luc Lachance Date: Fri, 6 Dec 2002 11:34:37 -0500 (EST) Cc: pgsql-sql X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/74 X-Sequence-Number: 10662 My book has a section on that: http://www.postgresql.org/docs/awbook.html Triggers are mostly for testing/modifying the row being inserted/updated, while rules are better for affecting other rows or other tables. 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? > > JLL > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073