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