>>>>> "Dean" == Dean Rasheed <dean.a.rasheed@gmail.com> writes:
Dean> That may be so, but we already support FILTER for all windowsDean> functions as well as aggregates:
Not so:
"If FILTER is specified, then only the input rows for which the
filter_clause evaluates to true are fed to the window function; other
rows are discarded. Only window functions that are aggregates accept a
FILTER clause."
(Per spec, FILTER appears only in the <aggregate function> production,
which is just one of the several options for <window function>.)
--
Andrew (irc:RhodiumToad)