Hi.
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.

/stig

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On Tuesday 10 October 2006 15:19, stig erikson wrote:
> Hi.
> 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.

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

---------------------------(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

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On Saturday 28 October 2006 19:47, Nicolas Barbier wrote:
> 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).
>

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

Centuries ago, Nostradamus foresaw when nicolas.barbier@gmail.com ("Nicolas Barbier") would write:
> 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).

I'm sure a good implementation would include such things.

I'm not sure it's anywhere near trivial to do so; it may be nontrivial
to efficiently do all those aggregates at once. We'll presumably
discover this if and when someone begins work on it...
--
"cbbrowne","@","gmail.com"
http://linuxdatabases.info/info/postgresql.html
"In the long run every program becomes rococo - then rubble."
-- Alan Perlis

Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when nicolas.barbier@gmail.com ("Nicolas Barbier") would write:
> > 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).
>
> I'm sure a good implementation would include such things.
>
> I'm not sure it's anywhere near trivial to do so; it may be nontrivial
> to efficiently do all those aggregates at once. We'll presumably
> discover this if and when someone begins work on it...

Our TODO has:

* Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq