Re: [HACKERS] Gsets: ROW expression semantic broken between 9.4 and 9.5 - Mailing list pgsql-bugs

From Andres Freund
Subject Re: [HACKERS] Gsets: ROW expression semantic broken between 9.4 and 9.5
Date
Msg-id 20150722184242.GA21169@awork2.anarazel.de
Whole thread Raw
In response to Gsets: ROW expression semantic broken between 9.4 and 9.5  (Jeevan Chalke <jeevan.chalke@enterprisedb.com>)
List pgsql-bugs
Hi,

On 2015-07-22 23:53:26 +0530, Jeevan Chalke wrote:
> It looks like we have broken the ROW expression without explicit
> ROW keyword in GROUP BY.

That was "intentional", and is actually standards required
behaviour. GROUP BY (a, b) is the same as GROUP BY a,b. It'd otherwise
be pretty confusing because parens in GROUPING SETS would mean something
different than in GROUP BY.

We should probably add a release note entry about it...

Thanks for testing gsets!

- Andres



pgsql-bugs by date:

Previous
From: Jeevan Chalke
Date:
Subject: Gsets: ROW expression semantic broken between 9.4 and 9.5
Next
From: b.yordanov2@gmail.com
Date:
Subject: BUG #13514: PostgreSQL backend process crashes on jsonb_object_agg()