Re: first_value/last_value - Mailing list pgsql-general

Is there a reason you can't do that now with a limit 1/order by/union all?
Just have it ordered one way on the first query and the other on the bottom. That will give you two rows that are the first / last in your set based on whatever column you order on.

On May 18, 2016 8:47 PM, "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

Thanks