Create Rule syntax.

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.

Responses

Browse pgsql-docs by date

  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