array_to_records function

Started by Yudie Pgover 18 years ago2 messagesgeneral
Jump to latest
#1Yudie Pg
yudiepg@gmail.com

Here I'm posting a function to convert array to records.
any other suggestions are welcome

create or replace function array_to_records(int[]) RETURNS SETOF record AS
$$
DECLARE
ret_rec record;
a int;
b int;
BEGIN
b = length(array_dims($1));
a = substr(array_dims($1),4, (b-4) );
FOR i IN 1.. a LOOP
FOR ret_rec IN select i, $1[i] LOOP
RETURN NEXT ret_rec;
END LOOP;
END LOOP;
RETURN;
END;
$$
LANGUAGE 'plpgsql';

#2Merlin Moncure
mmoncure@gmail.com
In reply to: Yudie Pg (#1)
Re: array_to_records function

On 9/6/07, Yudie Pg <yudiepg@gmail.com> wrote:

Here I'm posting a function to convert array to records.
any other suggestions are welcome

http://archives.postgresql.org/pgsql-general/2007-07/msg01240.php
http://people.planetpostgresql.org/merlin/index.php?/archives/4-fun-with-arrays.html

merlin