I forgot about very useful feature lile FILTER on window functions
select some_col, count(other_col) over() FILTER ( where other_col >
soime_val) Maybe in FB 4.0 it might be implemented


2018-11-10 9:47 GMT+01:00, Mark Rotteveel mark@...
[firebird-support] <firebird-support@yahoogroups.com>:

> On 9-11-2018 22:51, Michal Kurczabinski michkurc@...
> [firebird-support] wrote:
>> First thought:
>>
>> range/rows between unbounded preceding and unbounded following /
>> current row, etc..
>
> Will be added in Firebird 4 (already present in the Firebird 4 Alpha 1).
>
>> own aggregate functions in conjunction with window functions,
>
> There was a discussion about it on firebird-devel back in
> September/October, but I don't think there was anything conclusive yet.
>
>> list(column) over ...
>
> list does work as a window function, just not with an order by clause
> (that produces: feature is not supported, LIST is not supported in
> ordered windows); I'm not sure why it isn't supported for ordered
> windows though.
>
> Mark
>
> --
> Mark Rotteveel
>

--
pozdrawiam / regards,
Michał Kurczabiński