I need to use both in single sql. On Wed, May 18, 2016 at 9:08 PM, Adam Brusselback <adambrusselb...@gmail.com > wrote:
> 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" <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 >> >> Thanks >> >
