Thread: rules and command status question

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

Thanks in advance
Josh

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