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