Re: pl/pgsql and arrays[] - Mailing list pgsql-general

Oh sorry.
Seems I didn't tested simple cases.

Error happened when you work with record[] types and return setof:

create table test (id serial);
insert into test select generate_series(1,10);

CREATE OR REPLACE FUNCTION _test_array()
RETURNS SETOF test
LANGUAGE plpgsql
AS $$
DECLARE
    _array test[];
    _row   test%ROWTYPE;
BEGIN
     SELECT array(SELECT test FROM test) INTO _array;

     --work
     --_row := _array[1];
     --RETURN NEXT _row;

     --also work
     --RETURN QUERY SELECT (_array[1]).*;

     --error
     --RETURN NEXT _array[1];

     --error
     --RETURN NEXT (_array[1]);

     --error
     --RETURN NEXT (_array[1]).*;

     RETURN;   
END;
$$;