On 10 August 2010 17:06, Thom Brown <thom@xxxxxxxxx> wrote: > 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. > D'oh, no, I'm mistaken. My brain has been malfunctioning today. -- 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
