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:
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.
pgsql-sql by date
|Next:||From: Samuel Gendler||Date: 2012-04-24 20:08:23|
|Subject: Re: generic crosstab ?|
|Previous:||From: Steve Crawford||Date: 2012-04-24 18:56:06|
|Subject: Re: [SQL] Simple way to get missing number|