Re: Postgres 11 release notes - Mailing list pgsql-hackers

From Jonathan S. Katz
Subject Re: Postgres 11 release notes
Date
Msg-id 30468663-E67D-4753-8269-7E6A4001A281@excoventures.com
Whole thread Raw
In response to Re: Postgres 11 release notes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres 11 release notes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> On Jun 30, 2018, at 5:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> Yaroslav <ladayaroslav@yandex.ru> writes:
>> I've noticed the following in v11 release notes:
>> "Window functions now support all options shown in the SQL:2011 standard,
>> including RANGE distance PRECEDING/FOLLOWING, GROUPS mode, and frame
>> exclusion options"
> 
>> But, as far as I see, IGNORE NULLS option for lead, lag, etc. is still not
>> supported. May be, the item could be reformulated?
> 
> Mmm, yeah, I suppose it should say "all framing options" rather than
> implying that we've implemented every other window-related frammish
> there is in the spec.

+1. Attached patch that does exactly that.

Jonathan


Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Large Commitfest items
Next
From: David Rowley
Date:
Subject: Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath