Re: retrieve grouping sets/rollup rows

From: James Keener <jim(at)jimkeener(dot)com>
To: Tom Smith <tomsmith1989sk(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: retrieve grouping sets/rollup rows
Date: 2016-03-14 01:52:42
Message-ID: 56E6196A.4020607@jimkeener.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 David G. Johnston 2016-03-14 01:53:18 Re: Suppress decimal point like digits in to_char?
Previous Message Tom Smith 2016-03-14 01:45:40 retrieve grouping sets/rollup rows