Re: array to rows of it's elements?

This is the best that I can do with what I currenty know, so if you have a
better/faster solution, please send it my way:

CREATE OR REPLACE FUNCTION array_to_rows(myarray ANYARRAY) RETURNS SETOF
ANYELEMENT AS $$
BEGIN
FOR j IN 1..ARRAY_UPPER(myarray,1) LOOP
RETURN NEXT myarray[j];
END LOOP;
RETURN;
END;
$$ LANGUAGE 'plpgsql';

which I may then call like:

SELECT * FROM arrayto_rows(somearray);

Thanks
Celia McInnis

On Wed, 6 Jul 2005 09:37:10 -0500, Celia McInnis wrote
> Is there a function which will return the elements of an array as
> rows of entries? What I'd like in the 1 dimensional array case is
> something like:
>
> select array-to-rows(ARRAY[1,2,3]);
>
> giving
>
> 1
> 2
> 3
> (3 rows)
>
> Thanks,
> Celia McInnis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Open WebMail Project (http://openwebmail.org)