Re: crosstab

On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:

> Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
>> hi all
>> How could i use crostab to display variable number of columns. in the output
>> There could be variable number of columns
>
> see the documentation for Additional Supplied Modules, in your case
> tablefunc :
>
> http://www.postgresql.org/docs/9.1/static/tablefunc.html

I evaluated tablefunc about a year and a half ago and found that it was not what I wanted because you have to explicitly list what you want the columns to be. In some cases, there will be hundreds of columns in the pivoted table. The Reshape library in R can pivot tables without you even knowing ahead of time how many columns there are going to be. Maybe I need to revisit the documentation in case I missed something or if new functionality has been added since I last looked.

-Aram