Re: Hierarchical Queries--Stalled No Longer...

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:josh(at)agliodbs(dot)com]
Sent: Thursday, September 22, 2005 3:05 PM
To: pgsql-hackers(at)postgresql(dot)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