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