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