| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Create Rule syntax. |
| Date: | 2006-03-17 06:05:58 |
| Message-ID: | 20060317060558.33445.qmail@web31812.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2006-03-17 06:24:41 | Re: Create Rule syntax. |
| Previous Message | Scott Marlowe | 2006-03-13 16:29:16 | Re: vacuum and routine maintenance docs |