Re: rules and command status question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: rules and command status question
Date
Msg-id 20070925135306.GD6440@alvh.no-ip.org
Whole thread Raw
In response to rules and command status question  ("Josh Harrison" <joshques@gmail.com>)
List pgsql-general
Josh Harrison escribió:
> Hello,
> I have a question in the postgres document chapter 34. Rules and Command
> Status.
> The last paragraph of that page says that
>
> "The programmer can ensure that any desired INSTEAD rule is the one that
> sets the command status in the second case, by giving it the alphabetically
> last rule name among the active rules, so that it gets applied last."
>
> Can someone help me understand what this means. How can I change my INSERT
> ...INSTEAD rule so that query returns the number of rows inserted ( instead
> of 0 rows inserted).

You can't.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: lowering impact of checkpoints
Next
From: "Scott Marlowe"
Date:
Subject: Re: set returning functions.