--- On Mon, 12/10/07, Scott <[EMAIL PROTECTED]> 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 a table at a time.  If you want 
something different, you will have to use functions or triggers.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to