Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B0AA82E030A for ; Sun, 23 Dec 2007 17:22:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 81601-02-2 for ; Sun, 23 Dec 2007 17:22:05 -0400 (AST) Received: from sargon.lncsa.com (sargon.lncsa.com [212.99.8.251]) by postgresql.org (Postfix) with ESMTP id 7F9E72E00CB for ; Sun, 23 Dec 2007 17:22:07 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 8544F302790F for ; Sun, 23 Dec 2007 22:22:06 +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 Ye7Q6DaV3Udz for ; Sun, 23 Dec 2007 22:22:06 +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 65153300E87A for ; Sun, 23 Dec 2007 22:22:06 +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 9F99259C5B428 for ; Sun, 23 Dec 2007 22:22:05 +0100 (CET) Received: by timgad.apartia.fr (Postfix, from userid 1000) id 5B1B22C0692BB; Sun, 23 Dec 2007 22:22:05 +0100 (CET) Date: Sun, 23 Dec 2007 22:22:05 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: returning an array as a list fo single-column rows? Message-ID: <20071223212205.GA15367@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <20071223205557.GA14403@apartia.fr> <162867790712231319i35fb31el8d4c367bc313979b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <162867790712231319i35fb31el8d4c367bc313979b@mail.gmail.com> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/121 X-Sequence-Number: 29813 On Sun, Dec 23, 2007 at 10:19:26PM +0100, Pavel Stehule wrote: > Hello > > try > > create or replace function unpack(anyarray) > returns setof anyelement as $$ > select $1[i] > from generate_series(array_lower($1,1), array_upper($1,1)) g(i); > $$ language sql; > > postgres=# select * from unpack(array[1,2,3,4]); > unpack > -------- > 1 > 2 > 3 > 4 > (4 rows) Beautiful. Thank you.