Hello
try to use cursors
http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html
Regards
Pavel Stehule
2012/4/24 Andreas <maps.on@gmx.net>:
> Hi,
>
> is there a generic solution to dump the result of a query as a crosstab,
> when I can't know how many columns I will need?
>
> E.g. I get something like this:
>
> id, x
> 1, a
> 1, b
> 1, c
> 2, l
> 2, m
>
>
> and I'd like to see it as:
>
> id, x1, x2, x3, ..... xn
> 1, a, b, c, null, .... null
> 2, l, m, ....
>
> I fear the problem is I dont know n.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql