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