Postgres Pro
Downloads
Home   >   mailing lists

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

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

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pltcl: Invalid return list from trigger - must have even # of elements
Next
From: Bill McGonigle
Date:
Subject: Re: pg_dumpall storing multiple copies of DB's?