Re: PIVOT tables and crosstab

2009/12/11 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> 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.

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

>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>