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 9E510D1DCC0 for ; Sun, 18 Apr 2004 12:45:02 -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 66022-06 for ; Sun, 18 Apr 2004 12:45:00 -0300 (ADT) Received: from boss.intranet.noze.it (unknown [213.26.229.146]) by svr1.postgresql.org (Postfix) with ESMTP id D5D3CD1D085 for ; Sun, 18 Apr 2004 12:44:59 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by boss.intranet.noze.it (Postfix) with ESMTP id F36672628035 for ; Sun, 18 Apr 2004 17:44:58 +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 31999-04 for ; Sun, 18 Apr 2004 17:44:57 +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 BF6AA262800E for ; Sun, 18 Apr 2004 17:44:57 +0200 (CEST) Subject: Concatenate results of a single column query From: Marco Lazzeri To: pgsql-sql@postgresql.org Content-Type: text/plain Message-Id: <1082303095.5913.3.camel@macbeth.intranet.noze.it> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sun, 18 Apr 2004 17:44:55 +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/153 X-Sequence-Number: 17528 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