X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AB2A152807 for ; Fri, 20 May 2005 09:30:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50911-06 for ; Fri, 20 May 2005 12:30:49 +0000 (GMT) Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by svr1.postgresql.org (Postfix) with ESMTP id A3D6C52873 for ; Fri, 20 May 2005 09:30:47 -0300 (ADT) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id DC5DF18CFBC; Fri, 20 May 2005 08:31:08 -0400 (EDT) Received: from mailbox.samurai.com ([205.207.28.82]) by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new, port 10024) with LMTP id 15487-01-9; Fri, 20 May 2005 08:31:06 -0400 (EDT) Received: from [220.101.4.182] (r220-101-4-182.cpe.unwired.net.au [220.101.4.182]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id 1229418D29A; Fri, 20 May 2005 08:31:04 -0400 (EDT) Message-ID: <428DD88E.9090908@samurai.com> Date: Fri, 20 May 2005 22:31:10 +1000 From: Neil Conway User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robert Treat Cc: Kris Jurka , pgsql-docs@postgresql.org Subject: Re: create rule syntax References: <428D3F6D.1020108@samurai.com> <200505200756.53301.xzilla@users.sourceforge.net> In-Reply-To: <200505200756.53301.xzilla@users.sourceforge.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/34 X-Sequence-Number: 2999 Robert Treat wrote: > Sorry I missed this before, but the first examples use of create rule on > *object* rather than *table* seems like something important enough to keep, > since obviously rules can be on more than just tables. I can't get too excited about this. CREATE RULE uses "table" as well, and specifies that "table" really means "table or view". Similarly, the INSERT syntax summary talks about "INSERT INTO table ...", although of course you can insert into a view if the appropriate rule exists. A view is a table in more ways than one... -Neil