public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kris Jurka <[email protected]>
To: [email protected]
Subject: create rule syntax
Date: Wed, 11 May 2005 14:23:00 -0500 (EST)
Message-ID: <[email protected]> (raw)
The manual shows slightly different variations for the create rule
syntax here and here:
http://www.postgresql.org/docs/8.0/static/rules-update.html
http://www.postgresql.org/docs/8.0/static/sql-createrule.html
The attached patches makes the first look like the second. The key change
is that it shows how multiple actions are delimited:
(actions) vs. (command ; command ...)
Kris Jurka
Index: doc/src/sgml/rules.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/rules.sgml,v
retrieving revision 1.41
diff -c -r1.41 rules.sgml
*** doc/src/sgml/rules.sgml 29 Jan 2005 23:45:36 -0000 1.41
--- doc/src/sgml/rules.sgml 11 May 2005 19:19:59 -0000
***************
*** 902,910 ****
Keep the syntax
<programlisting>
! CREATE RULE <replaceable>rule_name</> AS ON <replaceable>event</>
! TO <replaceable>object</> [WHERE <replaceable>rule_qualification</>]
! DO [ALSO|INSTEAD] [<replaceable>action</> | (<replaceable>actions</>) | NOTHING];
</programlisting>
in mind.
--- 902,910 ----
Keep the syntax
<programlisting>
! CREATE [ OR REPLACE ] RULE <replaceable class="parameter">name</replaceable> AS ON <replaceable class="parameter">event</replaceable>
! TO <replaceable class="parameter">table</replaceable> [ WHERE <replaceable class="parameter">condition</replaceable> ]
! DO [ ALSO | INSTEAD ] { NOTHING | <replaceable class="parameter">command</replaceable> | ( <replaceable class="parameter">command</replaceable> ; <replaceable class="parameter">command</replaceable> ... ) }
</programlisting>
in mind.
Attachments:
[text/plain] rule-syntax.patch (1.2K, 2-rule-syntax.patch)
download | inline diff:
Index: doc/src/sgml/rules.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/rules.sgml,v
retrieving revision 1.41
diff -c -r1.41 rules.sgml
*** doc/src/sgml/rules.sgml 29 Jan 2005 23:45:36 -0000 1.41
--- doc/src/sgml/rules.sgml 11 May 2005 19:19:59 -0000
***************
*** 902,910 ****
Keep the syntax
<programlisting>
! CREATE RULE <replaceable>rule_name</> AS ON <replaceable>event</>
! TO <replaceable>object</> [WHERE <replaceable>rule_qualification</>]
! DO [ALSO|INSTEAD] [<replaceable>action</> | (<replaceable>actions</>) | NOTHING];
</programlisting>
in mind.
--- 902,910 ----
Keep the syntax
<programlisting>
! CREATE [ OR REPLACE ] RULE <replaceable class="parameter">name</replaceable> AS ON <replaceable class="parameter">event</replaceable>
! TO <replaceable class="parameter">table</replaceable> [ WHERE <replaceable class="parameter">condition</replaceable> ]
! DO [ ALSO | INSTEAD ] { NOTHING | <replaceable class="parameter">command</replaceable> | ( <replaceable class="parameter">command</replaceable> ; <replaceable class="parameter">command</replaceable> ... ) }
</programlisting>
in mind.
view thread (4+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected]
Subject: Re: create rule syntax
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox