Re: CUBE, ROLLUP, GROUPING SETS?

2006/10/28, Robert Treat <xzilla@users.sourceforge.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).

greetings,
Nicolas

--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html