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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/