Re: Sorted group by - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Sorted group by
Date
Msg-id alpine.DEB.2.00.1008101702100.2654@aragorn.flymine.org
Whole thread Raw
In response to Re: Sorted group by  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Sorted group by  (Thom Brown <thom@linux.com>)
Re: Sorted group by  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-performance
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?

Matthew

--
 Don't worry about people stealing your ideas. If your ideas are any good,
 you'll have to ram them down people's throats.     -- Howard Aiken

pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Sorted group by
Next
From: Thom Brown
Date:
Subject: Re: Sorted group by