How to combine many rows into one row (by concatenation?) ?

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to combine many rows into one row (by concatenation?) ?
Date: 2010-06-17 15:14:24
Message-ID: AANLkTimM8gYTu9diccGMslOZuQB585DQRO4q-ENCmH_9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi.

The table is table foo( id integer, x integer); and let the data be
id x
=====
1 10
1 20
2 20
3 30
3 10

Now I would like to get the data in a format like this

1 , 10 20
2 , 20
3 , 10 30

where id is the first field, and the second field is the x values sorted.

Is there a simple way to do this?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-06-17 15:15:32 Re: Runnning operating system commands from an SPL
Previous Message Andreas Kretschmer 2010-06-17 14:51:42 Re: Runnning operating system commands from an SPL