Re: retrieve grouping sets/rollup rows - Mailing list pgsql-general

From Tom Smith
Subject Re: retrieve grouping sets/rollup rows
Date
Msg-id CAKwSVFEBhOPnSwrnpNBmsAEs7-uNUdobWiJOcuXxicsSLU6cPQ@mail.gmail.com
Whole thread Raw
In response to Re: retrieve grouping sets/rollup rows  (James Keener <jim@jimkeener.com>)
Responses Re: retrieve grouping sets/rollup rows  (James Keener <jim@jimkeener.com>)
List pgsql-general
It would help if the resultset has some param to mark which is which with the grouping sets index.
for example, the results for (a,b,c,d) would be marked as for index =0,  (b,c,d) would be index=1

On Sun, Mar 13, 2016 at 9:52 PM, James Keener <jim@jimkeener.com> wrote:
Do you want to know if a row is from the (a,b) or (c,d) group?  All rows
will contain (a,b,c,d) but (a,b) will be NULL for the (c,d) grouping
sets, and vice-versa.

Jim

On 03/13/2016 09:45 PM, Tom Smith wrote:
> Hello:
>
> With JDBC, how can I tell which row is for which grouping sets or rollup
> using result sets
>
> Thanks
>
>

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Suppress decimal point like digits in to_char?
Next
From: Alvaro Herrera
Date:
Subject: Re: enum bug