\xC1\xBA\xFFАндрей Жидем\xAF\xFDков <pensnarik@gmail.com> writes: > Why FILTER is not implemented for non-aggregate functions?
The SQL standard only describes FILTER for aggregates. I'm not sure offhand whether it'd be semantically sensible for window functions. In any case, seems like most of the cases where you'd want it can be expressed equally well by putting the restriction into WHERE.