From: | Tom Smith <tomsmith1989sk(at)gmail(dot)com> |
---|---|
To: | Adam Brusselback <adambrusselback(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: first_value/last_value |
Date: | 2016-05-19 02:24:08 |
Message-ID: | CAKwSVFH2V6pXiAGNkD7X8LeE9vdhe-zHEuKO+v9nRRREYvfdVQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I need to use both in single sql.
On Wed, May 18, 2016 at 9:08 PM, Adam Brusselback <adambrusselback(at)gmail(dot)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" <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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Brusselback | 2016-05-19 02:36:33 | Re: first_value/last_value |
Previous Message | David G. Johnston | 2016-05-19 02:19:50 | Re: first_value/last_value |