Re: Re-write rules on views - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Re-write rules on views
Date
Msg-id 200202272328.g1RNSmW26497@candle.pha.pa.us
Whole thread Raw
In response to Re: Re-write rules on views  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re-write rules on views  (Rip <rip@onlineinfo.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Arguile"
Date:
Subject: Re: Drawing databases
Next
From: Tom Lane
Date:
Subject: Re: abnormal exits: what am I overlooking?