| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PIVOT tables and crosstab |
| Date: | 2009-12-11 14:12:13 |
| Message-ID: | 20091211141213.GA30833@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Pavel Stehule escribió:
> 2009/12/11 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> > I think the standard spelling of this feature is GROUPING SETS along
> > with syntactical sugar CUBE and ROLLUP. There was a patch for this
> > posted some time ago but it doesn't look like it has moved forward
> > lately.
> >
> > Barring GROUPING SETS, it is very unlikely that crosstab or pivot are
> > going to make it into the core.
>
> I plan start to work on GROUPING SETS early. What I know - GROUPING
> SETS feature is independent on PIVOT/UNPIVOT feature. Personally I
> thing so implementation of PIVOT is simpler than implementation of
> GROUPING SETS.
Hmm, but PIVOT is not on the standard, is it? As far as I can tell, the
standard wants one to use CUBE and ROLLUP for this kind of thing (and
the standard says that they are syntactical sugar for GROUPING SETS),
but it's possible that I am misreading what they are supposed to do.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2009-12-11 14:42:38 | Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. |
| Previous Message | CG | 2009-12-11 13:59:31 | Re: pg_dump and ON DELETE CASCADE problem |