| 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: | Whole Thread | Raw Message | 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
| 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? |