X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A2DFFD1D05C for ; Sun, 18 Apr 2004 11:36:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53060-01 for ; Sun, 18 Apr 2004 11:36:54 -0300 (ADT) Received: from boss.intranet.noze.it (unknown [213.26.229.146]) by svr1.postgresql.org (Postfix) with ESMTP id 004A3D1BB49 for ; Sun, 18 Apr 2004 11:36:50 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by boss.intranet.noze.it (Postfix) with ESMTP id B14CD2628035 for ; Sun, 18 Apr 2004 16:36:52 +0200 (CEST) Received: from boss.intranet.noze.it ([127.0.0.1]) by localhost (boss.intranet.noze.it [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 22411-10 for ; Sun, 18 Apr 2004 16:36:51 +0200 (CEST) Received: from macbeth.intranet.noze.it (macbeth.intranet.noze.it [192.168.0.70]) by boss.intranet.noze.it (Postfix) with ESMTP id CB90F262800E for ; Sun, 18 Apr 2004 16:36:51 +0200 (CEST) Subject: Concatenate results of a single column query From: Marco Lazzeri To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: noze S.r.l. Message-Id: <1082299009.5788.6.camel@macbeth.intranet.noze.it> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sun, 18 Apr 2004 16:36:49 +0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at noze.it X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/167 X-Sequence-Number: 17542 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