Thread: crosstab - pivot - transpose

crosstab - pivot - transpose

From
"SunWuKung"
Date:
Hi,
I will need to create a crosstab representation of my resultset.
The resultset looks like this: rowid, columnid, cellvalue
I don't know beforehand the number of columns and their id's but they
will be close to 200.

I have looked at the crosstab tablefunction but it seems that you have
to know your data in advance to use that. I looked at the posts here
and many said that it can (only/easily) be done in a language like
plperl.

Does somebody have an example for this simple case?

Thanks for the help.
Balázs