Re: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls
Date
Msg-id 87bn3n62da.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
>>>>> "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)



pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: "Allow usage of huge maintenance_work_mem for GIN build" patch
Next
From: Vladimir Borodin
Date:
Subject: Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6