Re: SQL:2003 Window Functions for postgresql 8.3?

Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > Bruce Momjian wrote:
> > > Karen Hill wrote:
> > > >
> > > > Alvaro Herrera wrote:
> > > > > Karen Hill wrote:
> > > > >
> > > > > > It would be really great if PostgreSQL supported SQL:2003 Window
> > > > > > functions. I know that oracle and sql server have them already, so it
> > > > > > would make postgres competitive in that area. I know there is a
> > > > > > feature freeze for 8.2, is it doable for 8.3?
> > > > >
> > > > > The sooner you start writing a patch, the sooner you will be done ;-)
> > > >
> > > > I looked at the TODO list at
> > > > http://www.postgresql.org/docs/faqs.TODO.html, and I don't see SQL:2003
> > > > Window Functions listed. Is it because they are not desired, or is it
> > > > because there are more pressing things to accomplish? I noticed that
> > > > Tom has mentioned that it appears unworkable in this thread.
> > >
> > > This is the first time I have seen them mentioned. Do we want them?
> >
> > They are in the standard and have been mentioned many times.
>
> Mentioned how? Window functions? I have seem people ask for them in
> the past week, but never before that.

Yeah, window functions. I remember Chris Kings-Lynne mentioning them
since at least a year ago ... Maybe the addition to the TODO was
stopped by the fact that anything specified by the SQL standard is
already a TODO, thus putting each item on the TODO is just redundant.

> What should the TODO be?

I guess "Implement SQL:2003 window functions" should be enough :-) Not
sure if you should append the [Karen Hill] bit to it though ;-)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.