Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group