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 m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com>: > On 9-11-2018 22:51, Michal Kurczabinski michk...@gmail.com > [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