Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 22C7F2E3028 for ; Sun, 23 Dec 2007 16:56:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 19878-07 for ; Sun, 23 Dec 2007 16:55:58 -0400 (AST) Received: from sargon.lncsa.com (sargon.lncsa.com [212.99.8.251]) by postgresql.org (Postfix) with ESMTP id 685542E2FB8 for ; Sun, 23 Dec 2007 16:56:01 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 7A0E9302790F for ; Sun, 23 Dec 2007 21:55:59 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at lncsa.com Received: from sargon.lncsa.com ([127.0.0.1]) by localhost (sargon.lncsa.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id cV6WTPaMmjp6 for ; Sun, 23 Dec 2007 21:55:59 +0100 (CET) Received: from zenon.apartia.fr (zenon.apartia.fr [10.0.3.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "zenon.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by sargon.lncsa.com (Postfix) with ESMTP id 56E7B300643D for ; Sun, 23 Dec 2007 21:55:59 +0100 (CET) Received: from timgad.apartia.fr (AToulouse-256-1-15-214.w90-38.abo.wanadoo.fr [90.38.98.214]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "timgad.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by zenon.apartia.fr (Postfix) with ESMTP id 92D5C59C5B428 for ; Sun, 23 Dec 2007 21:55:58 +0100 (CET) Received: by timgad.apartia.fr (Postfix, from userid 1000) id EC6812C0692BB; Sun, 23 Dec 2007 21:55:57 +0100 (CET) Date: Sun, 23 Dec 2007 21:55:57 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: returning an array as a list fo single-column rows? Message-ID: <20071223205557.GA14403@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/119 X-Sequence-Number: 29811 Hi, is there a way to return a Pg array as a list of single-column row values? I am trying to circumvent DBI's lack of support for native database arrays and return the list of values from an ENUM as a perl array. Thanks,