Skip site navigation (1) Skip section navigation (2)

Re: introduction of WIP window function patch

From: David Fetter <david(at)fetter(dot)org>
To: "H(dot)Harada" <umi(dot)tanuki(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: introduction of WIP window function patch
Date: 2008-07-17 07:28:59
Message-ID: 20080717072859.GB28307@fetter.org (view raw or flat)
Thread:
Lists: 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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

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

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2008-07-17 07:48:58
Subject: Re: pgsql: Allow TRUNCATE foo, foo to succeed, perreport from Nikhils.
Previous:From: Jan UrbaƄskiDate: 2008-07-17 06:35:14
Subject: Re: avoid recasting text to tsvector when calculating selectivity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group