X-Original-To: pgsql-docs@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 603154760E3 for ; Sun, 13 Apr 2003 23:47:04 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id AA30447580B for ; Sun, 13 Apr 2003 23:47:03 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3E3lX2L001570; Sun, 13 Apr 2003 23:47:33 -0400 (EDT) To: Sean Reifschneider Cc: pgsql-docs@postgresql.org Subject: Re: Docs patch to note that rules only get run once per query. In-reply-to: <20030413234349.GF7507@tummy.com> References: <20030413234349.GF7507@tummy.com> Comments: In-reply-to Sean Reifschneider message dated "Sun, 13 Apr 2003 17:43:49 -0600" Date: Sun, 13 Apr 2003 23:47:32 -0400 Message-ID: <1569.1050292052@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-29.1 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/23 X-Sequence-Number: 1749 Sean Reifschneider writes: > I've made the following patch to the current CVS docs. > + Note that rules are only invoked once per query. <> This still seems like a serious oversimplification or misexplanation to me. It's true that a rule creates only one new query to execute alongside each user-supplied query --- but that additional query can execute upon many individual rows. So I feel dissatisfied with the above "clarification". Can you think of another way to explain it? regards, tom lane