On 10 August 2010 17:03, Matthew Wakeling <matthew@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
