Multiple rows into one row

From: Raimon <coder(at)montx(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Multiple rows into one row
Date: 2008-02-02 15:13:20
Message-ID: EFEC7208-A1D0-48AD-83EA-94C968DA6C66@montx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I can't find any reference in PostgreSQL documentation, if this is
possible:

I want to have some rows in one column, with the values separated for
example by a comma.

SELECT name FROM animals WHERE customer_id = '5'

- cat
- dog
- turtle

I would like to have this like this:

- cat, dog, turtle

So I could issue a SELECT like this:

SELECT customer.name, (SELECT name FROM animals WHERE customer_id =
customer.id) AS animals FROM customer

name animals
------- -----------
Peter dog,cat
Lisa turtle
Anthony bird,elephant

I could find info about PIVOT and some other extra functionalities
from other databases like Oracle, SQL server, ...

thanks,

raimon

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike Ellsworth 2008-02-02 15:54:26 Re: Multiple rows into one row
Previous Message Robert M. Bernabe 2008-02-01 16:20:33 Re: Group Roles are now Login Roles in pgAdmin?