| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | WIP: grouping sets support | 
| Date: | 2008-10-17 10:16:05 | 
| Message-ID: | [email protected] | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Hello,
there is basic support of GROUPING SETS. This patch isn't ready for
production! It's only material for discus. Parser and executor are
done. Planner part should be completely rewritten. I don't understand
well to planner, and I haven't idea that parts should be shared with
groupby. Implementation is based on using hash tables that holds
result. It implements push mode via new node feeder.
Parser is ugly - there was two problems - 1. collision '(' ... ')'
between set spec and ROW constructor, 2. identificator cube shouldn't
be keyword (compatibility with cube contrib module).
I invite any help or comments. Without help I am not able to prepare
this patch for last commitfest. Help is necessary in two parts -
documentation, planner and testing. This version is based on CVS HEAD
before CTE patch!
knows limits:
* only hash aggregates are supported
* doe's somebody understand what's mean ALL in GROUP BY CLAUSE?
Regards
Pavel Stehule
| Attachment | Content-Type | Size | 
|---|---|---|
| gsets.diff.gz | application/x-gzip | 24.8 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-10-17 11:17:49 | Re: Cross-column statistics revisited | 
| Previous Message | Vladimir Sitnikov | 2008-10-17 09:30:50 | Re: contrib/pg_stat_statements |