Concatenate results of a single column query

From: Marco Lazzeri <marco(dot)lazzeri(at)noze(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: Concatenate results of a single column query
Date: 2004-04-18 14:36:49
Message-ID: 1082299009.5788.6.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, something
like the futurable (dev docs for 7.5)

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

Any suggestions?

Thanks
Marco

Browse pgsql-sql by date

  From Date Subject
Next Message Marco Lazzeri 2004-04-18 15:44:55 Concatenate results of a single column query
Previous Message Bruno Wolff III 2004-04-17 15:13:47 Re: Update is very slow on a bigger table