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(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
>
> Thanks
>