Re: generic crosstab ? - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: generic crosstab ?
Date
Msg-id CAFj8pRC7HmBQZ6wgW+T2-dPsG6yp3GYGwahJnA1+p4jy+CYqKw@mail.gmail.com
Whole thread Raw
In response to generic crosstab ?  (Andreas <maps.on@gmx.net>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Trinath Somanchi
Date:
Subject: Re: How to group by similarity?
Next
From: Samuel Gendler
Date:
Subject: Re: generic crosstab ?