From: Tom Lane <tgl@sss.pgh.pa.us>
To: Yaroslav <ladayaroslav@yandex.ru>
cc: pgsql-hackers@postgresql.org
Subject: Re: Postgres 11 release notes
In-reply-to: <1530395318134-0.post@n3.nabble.com>
References: <20180511150852.GA18510@momjian.us>
 <498A21C9-8FAC-4E15-BE28-284065970366@yandex-team.ru>
 <20180518135302.GE3088@momjian.us>
 <CAC8Q8tKbYmNdiyWr7hE4GfMY4fbqHKkFziKgrUuWHH6HJQs3og@mail.gmail.com>
 <CAPpHfdvKswa++gFQQWMZeUhpcg37vQigat1eNbrk0Q66_J=aSw@mail.gmail.com>
 <CAPpHfdtAwdXs4DHD3wBGn1yUdK0jytCQ2OunNbT8Luo7U=N51w@mail.gmail.com>
 <CAPpHfdtJJC9t17Zxd6WLAc9iSd5ip-SWZt8w-z0cqUwtwdbM6g@mail.gmail.com>
 <CAJnrtnxyst2iXvrygs=yZqNfWU-Zcrh-=MCvEizLquDEX4C-Rw@mail.gmail.com>
 <D36809DE-A3AB-494D-8A02-9EBD466F1B5D@yesql.se>
 <7F8963CE-9809-4A50-BF1F-3DD8DEC0FEB8@postgresql.org>
 <1530395318134-0.post@n3.nabble.com>
Comments: In-reply-to Yaroslav <ladayaroslav@yandex.ru>
	message dated "Sat, 30 Jun 2018 14:48:38 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <61820.1530395566.1@sss.pgh.pa.us>
Date: Sat, 30 Jun 2018 17:52:46 -0400
Message-ID: <61821.1530395566@sss.pgh.pa.us>
Precedence: bulk

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.

			regards, tom lane