Re: Re-write rules on views

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