PostgreSQL Documentation - Re: create rule syntax

Author

Re: create rule syntax

Neil Conway

2005-05-19, 8:24 pm

Kris Jurka wrote:
> The manual shows slightly different variations for the create rule
> syntax here and here:
>
> http://www.postgresql.org/docs/8.0/...les-update.html
> http://www.postgresql.org/docs/8.0/...createrule.html
>
> The attached patches makes the first look like the second.

Applied, thanks.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Robert Treat

2005-05-20, 7:23 am

On Thursday 19 May 2005 21:37, Neil Conway wrote:
> Kris Jurka wrote:
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Neil Conway

2005-05-20, 7:23 am

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)

Sponsored Links