Re: Insert Rule, Multiple Insert, Update Problem - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Insert Rule, Multiple Insert, Update Problem
Date
Msg-id 152664.76353.qm@web31803.mail.mud.yahoo.com
Whole thread Raw
In response to Insert Rule, Multiple Insert, Update Problem  (Scott <lists@mail.sael.com.au>)
List 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 by date:

Previous
From: Gerry Reno
Date:
Subject: Re: join on three tables is slow
Next
From: "Pavel Stehule"
Date:
Subject: Re: join on three tables is slow