Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
rules and command status question
- From: "Josh Harrison" <joshques(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: rules and command status question
- Date: Tue, 25 Sep 2007 09:19:54 -0400
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
- Follow-Ups:
- Re: rules and command status question
- From: Alvaro Herrera
- Re: rules and command status question
- Prev by Date: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
- Next by Date: Re: lowering impact of checkpoints
- Previous by thread: lowering impact of checkpoints
- Next by thread: Re: rules and command status question
- Indexes: