Search Postgresql Archives

Re: PIVOT tables and crosstab

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux