Re: proposal - GROUPING SETS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proposal - GROUPING SETS
Date
Msg-id 28756.1221573766@sss.pgh.pa.us
Whole thread Raw
In response to proposal - GROUPING SETS  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: proposal - GROUPING SETS  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: proposal - GROUPING SETS  ("Greg Stark" <stark@enterprisedb.com>)
List pgsql-hackers
"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> select a, b from t group by grouping sets(a, b);

> is same as:

> select a, NULL from t group by a
> union all
> select NULL, b from t group by b;

Really?  That seems utterly bizarre, not to say pointless.
You sure you read the spec correctly?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Subtransaction commits and Hot Standby
Next
From: Alvaro Herrera
Date:
Subject: Re: Subtransaction commits and Hot Standby