[GENERAL] Creating a PL/pgSQL function that returns multiple out parameters and refcursor

[Néstor Boscán]

Hi

Ho do I create a PL/pgSQL function that returns multiple out parameters and
a refcursor. Something like this:

create function myfunction(p_cursor out refcursor, p_code out varchar,
p_message out varchar) returns record as $$
  begin
    open p_cursor is select * from table;

    p_code := 'OK';
    p_message := 'message';

    return ???
  end;
$$ language plpgsql;