DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=xKqcCvP1LdWKdohFRO2K5KkflADYuRbwQAMg27sRLlXCs1vY1P4+mDkEkryIhy2A4KB8Dv+HC9/HrTlCU3W55don2nLKgeH1gJ8luWHi2xejrU+9tOA0gSOsFokFPZ39rXApfcoFWYlDI/Kyikk47H1q5hFeqMna7Zx+ptBldLw=
Message-ID: <162867790712231319i35fb31el8d4c367bc313979b@mail.gmail.com>
Date: Sun, 23 Dec 2007 22:19:26 +0100
From: "Pavel Stehule" <pavel.stehule@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: returning an array as a list fo single-column rows?
In-Reply-To: <20071223205557.GA14403@apartia.fr>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20071223205557.GA14403@apartia.fr>

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)

Regards
Pavel Stehule

On 23/12/2007, Louis-David Mitterrand
<vindex+lists-pgsql-sql@apartia.org> wrote:
> 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,
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>