| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)me(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PIVOT tables and crosstab |
| Date: | 2009-12-11 01:02:24 |
| Message-ID: | 20091211010224.GQ15554@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Simon Windsor wrote:
> Are there any plans to embed crosstab within the main release of
> Postgres, rather than as a Contrib component.
>
> Also, are there plans to enhance crosstab along the lines of Oracle 11g
> of pivot command?
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.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2009-12-11 01:07:49 | Re: Excessive (and slow) fsync() within single transaction |
| Previous Message | Greg Smith | 2009-12-11 01:00:03 | Re: Excessive (and slow) fsync() within single transaction |