Re: Re-write rules on views

Tom Lane wrote:
> Rip <rip(at)onlineinfo(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026