Concatenate results of a single column query - Mailing list pgsql-sql

From Marco Lazzeri
Subject Concatenate results of a single column query
Date
Msg-id 1082303095.5913.3.camel@macbeth.intranet.noze.it
Whole thread Raw
Responses Re: Concatenate results of a single column query  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
Hi All,
I would like to concatenate results of a single column query using
PostgreSQL 7.3.

Something like the coming feature

SELECT p.name, ARRAY(SELECT nicknames FROM people WHERE people.id = p.id)
FROM people AS p

(devel docs for 7.5:
http://developer.postgresql.org/docs/postgres/sql-expressions.html )

Any suggestions?

Thanks
Marco



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Update is very slow on a bigger table
Next
From: Greg Stark
Date:
Subject: Re: Concatenate results of a single column query