-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Hi guys,
I realized that the output of the CREATE RULE has not a detailed
output for the "events" parameter.
But the question here is that I'm not sure which format follow:
- --
{ INSERT | UPDATE | DELETE | SELECT}
or
INSERT
UPDATE
DELETE
SELECT
- --
I attach a patch for each one.
Regards,
- --
- --
Emanuel Calvo
Consultant // 2ndQuadrant
Bs. As., Argentina // (GMT-3)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.18 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBCgAGBQJTK05yAAoJEIBeI/HMagHmXEkQAJdXdqtPkRi8ZueupUYQxq9+
wJGOeBRGQRYLxZF2n6lqPy789JhjC8n9WyF5/In1zp9LAbbhLXQGaiR+Rueb5Xyv
c7m/4+qmrDnds8qTHtNZl7gdDqNm8Qbl8K5/puYKrifBBC6R11HrPiAGckbZuoB9
aO5GJn/qtBNVPDH+1MWhGXu4IRJpFNiH/BW5BD7R3vSMUaO4dbFxE9bmc9seeZL+
67SSMTANgROsjKkYP/roRRrYyW10AF3/20VLoFdfgYtXRDgo2eBJyR+TokjEhvce
h7EOROPpoNFkVHUpaN5UOMYmvlJH+D1IX6pex6nUsQ1YDI0mFJWV+UEKzozC3FO6
BFDRipsrTmzNxo+/BfLsRXhmmiHjaLlsLRZS3aiA41q3BxcbmL7lta4xIdxd+x9T
RCHzb96dJqrB2bp9PgaSgH/lxOqTwCQ4rylK3gUOeWpMU8TzLwyuy4bUD2bQYgFj
SkLl1aWYTs3WQFPQJ5tO2J3LO6hfvMbxBCAAloeqaghlo2uhnWHQpD+YIMR9/vGx
3bDiVMh2MWWWF4CNe9RQxW5jYwK8JtR79D5u6lNXK4zJ+NYJqYa3kUOprfZnVuM7
pH2EQEnMWQ6PdlSkNv/1lgRBXzb2rynaht9qzsWylhpiieM2+O6w7MsqsPNdPMP7
sii2/ymQmu5yatHo/Mwc
=rkEY
-----END PGP SIGNATURE-----
diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml
index d3212b5..22b46e2 100644
--- a/doc/src/sgml/ref/create_rule.sgml
+++ b/doc/src/sgml/ref/create_rule.sgml
@@ -24,6 +24,9 @@ PostgreSQL documentation
CREATE [ OR REPLACE ] RULE <replaceable class="parameter">name</replaceable> AS ON <replaceable class="parameter">event</replaceable>
TO <replaceable class="parameter">table_name</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> ... ) }
+
+<phrase>where <replaceable class="parameter">event</replaceable> can be one of:</phrase>
+ { INSERT | UPDATE | DELETE | SELECT}
</synopsis>
</refsynopsisdiv>
diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml
index d3212b5..a4df024 100644
--- a/doc/src/sgml/ref/create_rule.sgml
+++ b/doc/src/sgml/ref/create_rule.sgml
@@ -24,6 +24,12 @@ PostgreSQL documentation
CREATE [ OR REPLACE ] RULE <replaceable class="parameter">name</replaceable> AS ON <replaceable class="parameter">event</replaceable>
TO <replaceable class="parameter">table_name</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> ... ) }
+
+<phrase>where <replaceable class="parameter">event</replaceable> can be one of:</phrase>
+ INSERT
+ UPDATE
+ DELETE
+ SELECT
</synopsis>
</refsynopsisdiv>
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
