Re: Insert Rule, Multiple Insert, Update Problem

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: Insert Rule, Multiple Insert, Update Problem
Дата
Msg-id 152664.76353.qm@web31803.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Insert Rule, Multiple Insert, Update Problem  (Scott <lists@mail.sael.com.au>)
Список pgsql-sql
--- On Mon, 12/10/07, Scott <lists@mail.sael.com.au> wrote:

> I am having trouble with an insert rule that also does an
> update. It works
> fine for a single insert but multiple inserts in a single
> statement don't
> behave as I expected.

Yup,  that is the limitation of rules.  They are only useful if you issue statements that will only affect one tuple in
atable at a time.  If you want something different, you will have to use functions or triggers.
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: Gerry Reno
Дата:
Сообщение: Re: join on three tables is slow
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: join on three tables is slow