Josh, Great, thanks for the update. > It's a major feature implementation if > we want them to be at all worthwhile
agreed. SS 2005 added partial support for window functions (can't create moving windows of aggregation, ie, the portion of the syntax the standard calls the "framing clause") and I didn't like that. Imho, that wasn't cool at all. Either support these functions all the way or don't; halfway is silly. Btw, some of my postgres reviewers, when they came across recipes that used the new GENERATE_SERIES function, were quite happy (in particular for pivoting so you don't need to have extra tables lying around). It's a cool addition and I've gotten positive feedback from it. So, whoever dreamt it up, nice job. :) Thanks and regards, Anthony -----Original Message----- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 3:05 PM To: pgsql-hackers@postgresql.org Cc: Anthony Molinaro Subject: Re: [HACKERS] Hierarchical Queries--Stalled No Longer... Anthony, > also, while I got your ear. I bugged Simon about this > earlier this year and was wondering if you guys are still > planning on added the window functions added to the '03 standard? > > I have a ton of recipes that use them and if you guys are still > planning on implementing them, I'd like to mention that as well. Planning, yes. Have started, no. It's a major feature implementation if we want them to be at all worthwhile; I'd like users to be able to create custom windowing aggregates, for that matter. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
