On 29-9-2018 16:46, Karol Bieniaszewski wrote:
Hi,
Maybe i show my concept not so clearly.
Look how simple it is with my proposition and also how simple to
understand by users.
Your syntax looks too much like a normal function, which I think is
confusing.
How will your proposal work when the aggregate function is used in for
example a window function with an order by? In that case intermediate
results are needed.
Consider for example the difference between `count(*) over()` and
`count(*) over(order by something)`, or say something like (Firebird 4)
`avg(something) over(order by something rows between 5 preceding and 5
following)`.
I also don't see how your syntax discerns between accumulation and
finishing, for example how would the value of `accumulated` in
`custom_avg` be retained?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
