Re: first_value/last_value - Mailing list pgsql-general

From David G. Johnston
Subject Re: first_value/last_value
Date
Msg-id CAKFQuwbKavaWvQzxCe2ZCv1V+kQX43un14jrhZs0ffmF6g+rBQ@mail.gmail.com
Whole thread Raw
In response to first_value/last_value  (Tom Smith <tomsmith1989sk@gmail.com>)
List pgsql-general
On Wednesday, May 18, 2016, Tom Smith <tomsmith1989sk@gmail.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.

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: first_value/last_value
Next
From: Tom Smith
Date:
Subject: Re: first_value/last_value