Concatenate results of a single column query

From: Marco Lazzeri <marcomail(at)noze(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: Concatenate results of a single column query
Date: 2004-04-18 15:44:55
Message-ID: 1082303095.5913.3.camel@macbeth.intranet.noze.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2004-04-18 17:42:18 Re: Concatenate results of a single column query
Previous Message Marco Lazzeri 2004-04-18 14:36:49 Concatenate results of a single column query