Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug

From: Andres Freund <andres(at)anarazel(dot)de>
To: Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
Cc: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Atri Sharma <atri(dot)jiit(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Postgres-Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug
Date: 2015-07-26 14:13:41
Message-ID: 20150726141341.GD5143@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On 2015-07-17 11:37:26 +0530, Jeevan Chalke wrote:
> However I wonder why we are supporting GROUPING SETS inside GROUPING SETS.
> On Oracle, it is throwing an error.
> We are not trying to be Oracle compatible, but just curious to know.

The SQL specification seems to be pretty unambigous about supporting
nested grouping set specifications. Check 7.9 <group by
clause>: <grouping set> (nested inside a <grouping sets specification>)
can contain <grouping sets specification>.

Regards,

Andres

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2015-07-26 15:06:30 Re: [HACKERS] Gsets: ROW expression semantic broken between 9.4 and 9.5
Previous Message Noah Misch 2015-07-25 21:50:03 Re: contribcheck and modulescheck of MSVC's vcregress.pl cannot work independently

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2015-07-26 14:19:48 Re: A little RLS oversight?
Previous Message Tom Lane 2015-07-26 14:07:12 Re: Failing assertions in indxpath.c, placeholder.c and brin_minmax.c