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

From Dean Rasheed
Subject Re: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls
Date
Msg-id CAEZATCX9tEJGBkuOat__2amVckw_ZO=0FYRA3g2qPkRvSBUxdg@mail.gmail.com
Whole thread Raw
In response to Re: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
On 30 May 2016 at 15:44, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>>> "Dean" == Dean Rasheed <dean.a.rasheed@gmail.com> writes:
>
>  Dean> That may be so, but we already support FILTER for all windows
>  Dean> 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."
>

Ah, yes. It's all coming back to me now.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Vladimir Borodin
Date:
Subject: Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
Next
From: "David G. Johnston"
Date:
Subject: Re: regexp_match() returning text