Yes, good point. Already someone can do Infinite loop in stored procedure..
But, i try to minimize to have some special treatment like while loop and
susspend needed;
And there was a little error in my function it should be:
agg_i=0 if there is an ampty result set.
Agg_i will control the whole execution choices
create aggregate function custom_count_plus_1000 (i integer) returns (o
integer)
as
Begin
If (agg_i<=1) then
Begin
--init vars and more
o = 0;
end;
-- here body of this function
-- do whatever you want
If (agg_i>=1) then
o= o + 1;
if (agg_finished and (agg_i>0)) then
o = o + 1000;
end
Regards,
Karol Bieniaszewski
Od: Adriano dos Santos Fernandes
Wysłano: piątek, 28 września 2018 21:43
Do: [email protected]
Temat: Re: [Firebird-devel] ODP: User-defined aggregate functions
Karol,
If user code something wrongly or create inifinite loops, wrongly
results he/she will have, no matter how things are defined.
I like your opinion to not limit to only one input parameters. This
limitation seems to not have sense.
Adriano
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
