On Sat, Jul 05, 2008 at 07:04:29PM +0900, H.Harada wrote:
> 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.
> 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.
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?
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
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2008-07-17 07:48:58|
|Subject: Re: pgsql: Allow TRUNCATE foo, foo to succeed, perreport from Nikhils.|
|Previous:||From: Jan Urbański||Date: 2008-07-17 06:35:14|
|Subject: Re: avoid recasting text to tsvector when calculating selectivity|