2019-03-12 16:56 GMT+01:00, Mark Rotteveel mark@...
[firebird-support]

>
> 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

Great!

> 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).

You're right :)

--
regards,
Michał Kurczabiński