Re: Sorted group by

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