Re: CUBE, ROLLUP, GROUPING SETS?

On Saturday 28 October 2006 19:47, Nicolas Barbier wrote:
> 2006/10/28, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>:
> > On Tuesday 10 October 2006 15:19, stig erikson wrote:
> >> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
> >> future PostgreSQL versions? I could not find any info on the TODO-page.
> >
> > I've heard people mention it, but no one has ever come up with a solid
> > proposal or patch. Depending on what your doing there are ways to
> > simulate those things with more standard sql.
>
> CUBE, ROLLUP and GROUPING SETS are at least part of SQL 2003.
> Supporting them would probably also include optimized ways to execute
> them, like calculating all aggregations in one run for ROLLUP (instead
> of doing multiple scans).
>

I didn't say anyone was against the idea, just that we've yet to see someone
with the appropriately shaped tuits show up...

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL