From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Tom Smith <tomsmith1989sk(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: first_value/last_value |
Date: | 2016-05-19 02:19:50 |
Message-ID: | CAKFQuwbKavaWvQzxCe2ZCv1V+kQX43un14jrhZs0ffmF6g+rBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday, May 18, 2016, Tom Smith <tomsmith1989sk(at)gmail(dot)com> wrote:
> Hello:
>
> Is there a plan for 9.7 to enable using the two aggregate function
> as non-window function? i.e. enabling getting the first/last row
> in single sql without using window features.
> There is actually a C-extension for first()/last().
> I am wondering if 9.7 would make them built-in function like max/min
>
>
The "distinct on" capability provides this for at least some use cases.
Given this is first I've even seen a gripe on this, and the window versions
have existed for something like 6 years, I'd have to say this isn't high on
anyone's radar.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Smith | 2016-05-19 02:24:08 | Re: first_value/last_value |
Previous Message | Adam Brusselback | 2016-05-19 01:08:11 | Re: first_value/last_value |