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

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


pgsql-sql by date

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

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