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: | Raw Message | Whole Thread | 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 |