From: Richard Broersma Jr <rabroersma@yahoo.com>
To: pgsql-docs@postgresql.org
Subject: Create Rule syntax.
Date: Thu, 16 Mar 2006 22:05:58 -0800 (PST)
Message-ID: <20060317060558.33445.qmail@web31812.mail.mud.yahoo.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: rabroersma@yahoo.com
Subject: Re: Create Rule syntax.
In-Reply-To: <20060317060558.33445.qmail@web31812.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox