On 5/30/24 15:34, johnlu...@hotmail.com wrote:
On 5/30/24 4:56 PM, David G. Johnston wrote:
Very little interest exists in working on user-specified rules. They
are practically deprecated.
Ah - pity - see my last comment to Adrian's
Any interest in perhaps providing a choice
> On 31 May 2024, at 00:34, johnlu...@hotmail.com wrote:
>
> On 5/30/24 4:56 PM, David G. Johnston wrote:
(…)
>> If anything is done it would have to be new syntax.
>>
>>
> A much bigger task surely.
>
> On 5/30/24 5:19 PM, Adrian Klaver wrote:
>>
>> 2) Use INSTEAD OF triggers:
>>
>>
"johnlu...@hotmail.com" writes:
> But I suppose that my next question, given what you both say about the
> RULE system being a dead-end, is whether there is any likelihood of
> supporting an INSTEAD OF trigger on a view at statement level? Maybe
> that stands more chance of going somewhere
On 5/30/24 4:56 PM, David G. Johnston wrote:
Very little interest exists in working on user-specified rules. They
are practically deprecated.
Ah - pity - see my last comment to Adrian's
Any interest in perhaps providing a choice via a configuration
parameter?
If anythi
On 5/30/24 11:32, johnlu...@hotmail.com wrote:
Any thoughts? Any rationales one way or the other? Any interest
in perhaps providing a choice via a configuration parameter?
1) As to using rules, stop now before you invest the time to find out is
a road you don't want to go down.
2) U
On Thu, May 30, 2024, 12:32 johnlu...@hotmail.com
wrote:
> Any thoughts?
>
Very little interest exists in working on user-specified rules. They are
practically deprecated.
>
> Any interest in perhaps providing a choice via a configuration
> parameter?
>
Almost certainly not. Configuration
The RULE infrastructure permits the programmer to specify a series of
commands in the DO action
from the syntax diagram in the manual :
CREATE [ OR REPLACE ] RULE name AS ON event
TO table [ WHERE condition ]
DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }
The
