| From: | "Jonathan S(dot) Katz" <jonathan(dot)katz(at)excoventures(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Yaroslav <ladayaroslav(at)yandex(dot)ru>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Postgres 11 release notes |
| Date: | 2018-07-01 19:57:38 |
| Message-ID: | 30468663-E67D-4753-8269-7E6A4001A281@excoventures.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
> On Jun 30, 2018, at 5:52 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Yaroslav <ladayaroslav(at)yandex(dot)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 | Content-Type | Size |
|---|---|---|
| 0001-window-docs.patch | application/octet-stream | 927 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-07-01 21:37:31 | Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath |
| Previous Message | Andres Freund | 2018-07-01 18:50:47 | Re: Large Commitfest items |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Natalia Piskunova | 2018-07-02 17:39:02 | PostgreSQL for beginners book |
| Previous Message | Tom Lane | 2018-06-30 21:52:46 | Re: Postgres 11 release notes |