--- 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