Home > mailing lists

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

From	Marco Lazzeri
Subject	Concatenate results of a single column query
Date	April 19, 2004 17:05:42
Msg-id	1082299009.5788.6.camel@macbeth.intranet.noze.it Whole thread Raw
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: CoL
Date: 19 April 2004, 16:59:03
Subject: Re: Concatenate results of a single column query

From: Pallav Kalva
Date: 19 April 2004, 17:26:53
Subject: Querying From two databases

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

Previous

Next