Re: Deprecating RULES

On 10/17/2012 01:02 PM, Joshua D. Drake wrote:
>
> On 10/17/2012 02:48 AM, Simon Riggs wrote:
>
>> Would you or someone else be able to come up with some words of
>> caution for us to put in the manual that would be helpful to
>> developers?
>>
>> There isn't even a list of caveats for rules.
>
> I think we need the inverse. Some documentation on why to use rules 
> and this basically boils down to the problem. Can anyone tell me a 
> reason to use explicit rules over a trigger and function combination?
>
>

I don't know how many times I have to say this: people are not 
listening. Tom has already given a case for it upthread:

>> Triggers necessarily operate on a row-at-a-time basis.  In theory,
>> for at least some bulk operations, a rule could greatly outperform
>> a trigger.  It's difficult to walk away from that - unless somebody
>> can prove that the advantage doesn't ever accrue in practice.
>


People can keep ignoring that if they like, but some of us won't. This 
mantra of "there is no reason at all to use rules" is like climate 
change denial - no matter how many times you say it that won't make it true.


cheers

andrew