generic crosstab ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: generic crosstab ?
Date: 2012-04-24 20:01:31
Message-ID: 4F97069B.7020303@gmx.net
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Samuel Gendler 2012-04-24 20:08:23 Re: generic crosstab ?
Previous Message Steve Crawford 2012-04-24 18:56:06 Re: [SQL] Simple way to get missing number