Re: introduction of WIP window function patch - Mailing list pgsql-hackers

From David Fetter
Subject Re: introduction of WIP window function patch
Date
Msg-id 20080717072859.GB28307@fetter.org
Whole thread Raw
In response to introduction of WIP window function patch  (H.Harada <umi.tanuki@gmail.com>)
Responses Re: introduction of WIP window function patch
List pgsql-hackers
On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote:
> Hi,
> 
> As I proposed a month before, I am working on window function.
> Although this work is at quite early step, I would like to introduce
> it since a part of it have been finished. If you can afford and are
> interested in it, please review the document and patch, or compile the
> applied source to execute an attached sample SQL.
> 
> http://umitanuki.net/pgsql/wfv01/design.html
> 
> Currently, only aggregation over window does work. I am planning to
> work for the combination of window and normal aggregation from now on,
> which I guess I can manage to do.
> 
> The problem is, as written in the "Things to discussed" section of the
> document, how you define window functions (e.g. RANK()). My idea is to
> treat them as specialized functions such as SET OF functions and mark
> it in pg_proc. But this doesn't resolve RANK() boundary problem.
> 
> I am so happy with any kind of comments, reviews or critiques.
> 
> Regards,

Many people have been waiting for years for this functionality.
Thanks so much for doing this.

When will you have another patch that applies against CVS HEAD?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Jan Urbański
Date:
Subject: Re: avoid recasting text to tsvector when calculating selectivity
Next
From: Tatsuo Ishii
Date:
Subject: Re: [PATCHES] WITH RECURSIVE updated to CVS TIP