generic crosstab ? - Mailing list pgsql-sql

From Andreas
Subject generic crosstab ?
Date
Msg-id 4F97069B.7020303@gmx.net
Whole thread Raw
Responses Re: generic crosstab ?  (Samuel Gendler <sgendler@ideasculptor.com>)
Re: generic crosstab ?  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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.


pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Simple way to get missing number
Next
From: Samuel Gendler
Date:
Subject: Re: generic crosstab ?