Re: retrieve grouping sets/rollup rows

From: Tom Smith <tomsmith1989sk(at)gmail(dot)com>
To: James Keener <jim(at)jimkeener(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: retrieve grouping sets/rollup rows
Date: 2016-03-14 02:07:25
Message-ID: CAKwSVFEBhOPnSwrnpNBmsAEs7-uNUdobWiJOcuXxicsSLU6cPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jimkeener(dot)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
> >
> >
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2016-03-14 02:08:26 Re: enum bug
Previous Message David G. Johnston 2016-03-14 01:53:18 Re: Suppress decimal point like digits in to_char?