On 2019-03-12 13:13, Michal Kurczabinski michkurc@...
[firebird-support] wrote:

> 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

FILTER has been implemented in Firebird 4. See "FILTER Clause for
Aggregate Functions" in the Firebird 4 beta 1 release notes, or
http://tracker.firebirdsql.org/browse/CORE-5768

Note though that the order you mention is not right, it right order
would be count(other_col) filter (where other_col > soime_val) over(),
or filter-clause before window-clause(that is also the order in
PostgreSQL).

Mark