SELECT O.ID, O.NAME
FROM U_GET_OBJ_LIST('210010213') OL
  LEFT JOIN U_GET_OBJ(OL.ID) O ON  1 = 1 
WHERE O.TYPE = 'simple_text'

CREATE PROCEDURE S_GET_PARTNER_LIST(
    PID INTEGER)
RETURNS (
    ID INTEGER,
    CITY INTEGER,
    BRAND INTEGER)
AS

create function getmy returns record as $$
begin
  my.int_field :=  15 ;
  my.float_field :=  10 . 76 ;
  my.text_field := 'Yohoho!!!';
  return my;
end
$$

select * from my();

|---int_field---|---float_field---|---text_field---|
|---15----------|---10.76---------|---Yohoho!!!----|

declare
       my my_row;
       i integer;
begin

     for i in  1 .. 15 
     loop
     begin

     my.int_field := i;
     my.float_field :=  0 . 86 ;
     my.text_field := 'Yohoho!!!';

     end;
     end loop;
     return my;
     
end;

CREATE TABLE "public"."test_data" (
  "id" INTEGER NOT NULL, 
  "type" INTEGER NOT NULL, 
  "short_text" VARCHAR( 255 ), 
  CONSTRAINT "test_data_pkey" PRIMARY KEY("id")
) WITH OIDS;

CREATE TYPE "public"."ret_id" AS (
  "id" INTEGER
);

CREATE TYPE "public"."test" AS (
  "id" INTEGER,
  "type" INTEGER,
  "info" VARCHAR( 255 )
);

CREATE OR REPLACE FUNCTION "public"."get_obj_list" () RETURNS SETOF "public"."ret_id" AS
$body$
declare
       ret ret_id;
begin

     for ret in select test_data.id from test_data
     loop

     return next ret;
     
     end loop;

end;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

CREATE OR REPLACE FUNCTION "public"."get_obj" (id integer) RETURNS "public"."test" AS
$body$
declare
       ret test;
       in_id alias for $ 1 ;
       
begin

     select * from test_data a into ret where a.id=in_id;
     return ret;

end;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

select a.id, b.*
from get_obj_list() a
  left join get_obj(a.id) b on  1 = 1