I can't find any reference in PostgreSQL documentation, if this is
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'
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
I could find info about PIVOT and some other extra functionalities
from other databases like Oracle, SQL server, ...
In response to
pgsql-novice by date
|Next:||From: Mike Ellsworth||Date: 2008-02-02 15:54:26|
|Subject: Re: Multiple rows into one row|
|Previous:||From: Robert M. Bernabe||Date: 2008-02-01 16:20:33|
|Subject: Re: Group Roles are now Login Roles in pgAdmin?|