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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
