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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers