Re: Final Patch for GROUPING SETS

On 09/17/2014 03:02 PM, Marti Raudsepp wrote:
> So instead of:
>  GroupAggregate
>    Output: four, ten, hundred, count(*)
>    Grouping Sets: (onek.four, onek.ten, onek.hundred), (onek.four,
> onek.ten), (onek.four), ()
> 
> Perhaps print:
>    Grouping Sets: (onek.four, onek.ten, onek.hundred)
>                   (onek.four, onek.ten)
>                   (onek.four)
>                   ()

So:
 Grouping Sets: [    [ onek.four, onek.ten, onek.hundred ],    [ onek.four, onek.ten ],    [ onek.four ],    []]

.. in JSON?

Seems to me that we need a better way to display the grand total
grouping set.

> 
> Or maybe:
>    Grouping Set: (onek.four, onek.ten, onek.hundred)
>    Grouping Set: (onek.four, onek.ten)
>    Grouping Set: (onek.four)
>    Grouping Set: ()

The latter won't work with JSON and YAML output.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com