| Lists: | pgsql-docs |
|---|
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | create rule syntax |
| Date: | 2005-05-11 19:23:00 |
| Message-ID: | Pine.BSO.4.56.0505111420440.435@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
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
| Attachment | Content-Type | Size |
|---|---|---|
| rule-syntax.patch | text/plain | 1.2 KB |
| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: create rule syntax |
| Date: | 2005-05-20 01:37:49 |
| Message-ID: | 428D3F6D.1020108@samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Kris Jurka wrote:
> 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.
Applied, thanks.
-Neil
| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Kris Jurka <books(at)ejurka(dot)com>, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: create rule syntax |
| Date: | 2005-05-20 11:56:53 |
| Message-ID: | 200505200756.53301.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
On Thursday 19 May 2005 21:37, Neil Conway wrote:
> Kris Jurka wrote:
> > 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.
>
> Applied, thanks.
Sorry I missed this before, but the first examples use of create rule on
*object* rather than *table* seems like something important enough to keep,
since obviously rules can be on more than just tables.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | Kris Jurka <books(at)ejurka(dot)com>, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: create rule syntax |
| Date: | 2005-05-20 12:31:10 |
| Message-ID: | 428DD88E.9090908@samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Robert Treat wrote:
> Sorry I missed this before, but the first examples use of create rule on
> *object* rather than *table* seems like something important enough to keep,
> since obviously rules can be on more than just tables.
I can't get too excited about this. CREATE RULE uses "table" as well,
and specifies that "table" really means "table or view". Similarly, the
INSERT syntax summary talks about "INSERT INTO table ...", although of
course you can insert into a view if the appropriate rule exists. A view
is a table in more ways than one...
-Neil