X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1C2769DCA24 for ; Fri, 17 Mar 2006 02:06:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21096-09 for ; Fri, 17 Mar 2006 02:06:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31812.mail.mud.yahoo.com (web31812.mail.mud.yahoo.com [68.142.207.75]) by postgresql.org (Postfix) with SMTP id 8CE289DC874 for ; Fri, 17 Mar 2006 02:05:58 -0400 (AST) Received: (qmail 33447 invoked by uid 60001); 17 Mar 2006 06:05:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=4SdKZN4x3C/W3nXCqILP8YxYda3qOSXVjxtYtw0eMmBMa0rUcxajGKXS3FTKAKJQfrS1K80RXmw1XUyQ+sZHrL/vlvj9a6DzxPt0ocRkLgbd/ZDQWMOfscdaCmUjXSD1KQZGT/i6xXCd1sPzlX9TMBTlpxj1VrH8NHu2Fjs4cWU= ; Message-ID: <20060317060558.33445.qmail@web31812.mail.mud.yahoo.com> Received: from [68.235.218.116] by web31812.mail.mud.yahoo.com via HTTP; Thu, 16 Mar 2006 22:05:58 PST Date: Thu, 16 Mar 2006 22:05:58 -0800 (PST) From: Richard Broersma Jr Subject: Create Rule syntax. To: pgsql-docs@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/13 X-Sequence-Number: 3470 Hopefully this is the correct list to post this message. I was comparing the rendering of the Create Rule Syntax regarding "(actions)" from the page: http://www.postgresql.org/docs/8.0/interactive/rules-update.html CREATE RULE rule_name AS ON event TO object [WHERE rule_qualification] DO [ALSO|INSTEAD] [action | (actions) | NOTHING]; ^^^^^^^^^ to the syntax from the psql \h create rule. Syntax: CREATE [ OR REPLACE ] RULE name AS ON event TO table [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) } ^^^^^^^^^^^^^^^^^^^^^^^^^ The diffences are not major. However, for a newbie like myself I felt the syntax of "(actions)" was a little vague. Regards, Richard Broersma Jr.