Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[GENERAL] PIVOT tables and crosstab

8 views
Skip to first unread message

Simon Windsor

unread,
Dec 10, 2009, 7:06:47 PM12/10/09
to
Hi

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?

All the best Simon

--
Simon Windsor
Eml: simon....@cornfield.me.uk
Tel: 01454 617689
Mob: 07590 324560

“There is nothing in the world that some man cannot make a little worse
and sell a little cheaper, and he who considers price only is that man's
lawful prey."


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

Greg Smith

unread,
Dec 10, 2009, 7:40:40 PM12/10/09
to
Simon Windsor wrote:
> Are there any plans to embed crosstab within the main release of
> Postgres, rather than as a Contrib component.
>
contrib components are within the main release of PostgreSQL as far as
the core project is concerned. Sometimes downstream packagers fail to
include them or break them into a separate, optional package, but
they're nonetheless part of the official source code release.

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
gr...@2ndQuadrant.com www.2ndQuadrant.com

Alvaro Herrera

unread,
Dec 10, 2009, 8:02:24 PM12/10/09
to
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

Pavel Stehule

unread,
Dec 11, 2009, 1:52:28 AM12/11/09
to
2009/12/11 Alvaro Herrera <alvh...@commandprompt.com>:

> 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.

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.

Regards
Pavel Stehule

Alvaro Herrera

unread,
Dec 11, 2009, 9:12:13 AM12/11/09
to
Pavel Stehule escribi�:
> 2009/12/11 Alvaro Herrera <alvh...@commandprompt.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.

Pavel Stehule

unread,
Dec 11, 2009, 10:32:21 AM12/11/09
to
2009/12/11 Alvaro Herrera <alvh...@commandprompt.com>:
> Pavel Stehule escribió:

>> 2009/12/11 Alvaro Herrera <alvh...@commandprompt.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.

Yes - PIVOT is not in standard now. But it could be in standard. It
isn't replaceable with GROUPING SETS - It is total different.

Pavel

0 new messages