Re: first_value/last_value

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, May 18, 2016, Tom Smith <tomsmith1989sk@xxxxxxxxx> 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.