Re: Re-write rules on views

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Re-write rules on views
Дата
Msg-id 200202272328.g1RNSmW26497@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Re-write rules on views  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re-write rules on views
Список 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 по дате отправления:

Предыдущее
От: "Arguile"
Дата:
Сообщение: Re: Drawing databases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: abnormal exits: what am I overlooking?