Re: introduction of WIP window function patch

2008/7/17 David Fetter <david(at)fetter(dot)org>:
> 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
>

As you see the patch is not completed yet, lacking RANK() etc. I am
now struggling for this design which I assume will finish by the end
of this month. Since then, I will apply it against HEAD. So another
patch to -hackers will be around first half of August, or by the next
Commit Fest at worst.

There must be more discussion about the RANK() design after the post.
But I hope it will be in 8.4.

Regards,

--
Hitoshi Harada