| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | Matthew Wakeling <matthew(at)flymine(dot)org> |
| Cc: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Sorted group by |
| Date: | 2010-08-10 16:06:16 |
| Message-ID: | AANLkTikaYYY0xftv=1nqPQZWbqiqyOgaSLz69cV_OcMo@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 10 August 2010 17:03, Matthew Wakeling <matthew(at)flymine(dot)org> wrote:
> On Tue, 10 Aug 2010, Thomas Kellerer wrote:
>>
>> No. It's built in (8.4) and it's called Windowing functions:
>> http://www.postgresql.org/docs/8.4/static/tutorial-window.html
>> http://www.postgresql.org/docs/8.4/static/functions-window.html
>>
>> SELECT group, last_value(value) over(ORDER BY number)
>> FROM table
>
> I may be mistaken, but as I understand it, a windowing function doesn't
> reduce the number of rows in the results?
>
I think you are mistaken. The last_value function is a window
function aggregate. Give it a try.
--
Thom Brown
Registered Linux user: #516935
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2010-08-10 16:11:07 | Re: Sorted group by |
| Previous Message | Matthew Wakeling | 2010-08-10 16:03:40 | Re: Sorted group by |