Re: GROUPING SETS revisited - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: GROUPING SETS revisited
Date
Msg-id AANLkTi=QMFmABuH1Wky+X3QV42v2qzP6a7u0EPBMbwTu@mail.gmail.com
Whole thread Raw
In response to Re: GROUPING SETS revisited  (Hitoshi Harada <umi.tanuki@gmail.com>)
List pgsql-hackers
Hello

I found a break in GROUPING SETS implementation. Now I am playing with
own executor and planner node and I can't to go forward :(. Probably
this feature will need a significant update of our agg implementation.
Probably needs a some similar structure like CTE but it can be a
little bit reduced - there are a simple relation between source query
and result query - I am not sure, if this has to be implemented via
subqueries? The second question is relative big differencies between
GROUP BY behave and GROUP BY GROUPING SETS behave. Now I don't know
about way to join GROUP BY and GROUPING SETS together

Any ideas welcome

Regards

Pavel


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: git: uh-oh
Next
From: Robert Haas
Date:
Subject: Re: security label support, part.2