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.