Re: Re-write rules on views

Thanx for the help. Actually I discovered the real problem.... it's a php
bug. when php hits the ';' in the multiple action it assumes the query is
over and starts a new one. I'll post this bug report to php and back to the
list.

At 06:28 PM 2/27/02 -0500, you wrote:
>Tom Lane wrote:
> > Rip <rip@onlineinfo.net> writes:
> > >     The docs seem slim in this department.. what is the proper
> > > syntax for an update to a view with multiple tables?
> >
> > I think you are looking for a multiple-action rule.  Just put square
> > brackets, or parens if you prefer, around the list of action queries.
>
>I recommend parens. Brackets are going away in 7.3.  TODO has:
>
>         * Remove brackets as multi-statement rule grouping, must use parens
>
>and I will attack that easy one soon. :-)
>
>--
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026