在plsql - postgresql中创建对象列表

DECLARE
   TYPE object_list IS TABLE OF object_type;
   obj_list object_list;
BEGIN
   obj_list := object_list();
   
   -- 添加对象到列表
   obj_list.EXTEND;
   obj_list(1) := object_type('Object 1');
   
   obj_list.EXTEND;
   obj_list(2) := object_type('Object 2');
   
   -- 遍历对象列表
   FOR i IN 1..obj_list.COUNT LOOP
      DBMS_OUTPUT.PUT_LINE(obj_list(i).name);
   END LOOP;
END;
/

DECLARE
   TYPE object_list IS TABLE OF object_type INDEX BY PLS_INTEGER;
   obj_list object_list;
BEGIN
   -- 添加对象到列表
   obj_list(1) := object_type('Object 1');
   obj_list(2) := object_type('Object 2');
   
   -- 遍历对象列表
   FOR i IN 1..obj_list.COUNT LOOP
      DBMS_OUTPUT.PUT_LINE(obj_list(i).name);
   END LOOP;
END;
/

CREATE TYPE object_type AS (
   name VARCHAR,
   -- 其他属性
);

-- 创建对象列表
CREATE OR REPLACE FUNCTION create_object_list()
   RETURNS object_type[] AS $$
DECLARE
   obj_list object_type[];
BEGIN
   obj_list := ARRAY[
      ROW('Object 1'::VARCHAR),
      ROW('Object 2'::VARCHAR)
   ];
   
   RETURN obj_list;
END;
$$ LANGUAGE plpgsql;

-- 调用函数获取对象列表
SELECT * FROM create_object_list();

CREATE TYPE object_type AS (
   name VARCHAR,
   -- 其他属性
);

-- 创建对象列表表
CREATE TABLE object_list (
   object object_type
);

-- 插入对象到列表
INSERT INTO object_list VALUES
   (ROW('Object 1'::VARCHAR)),
   (ROW('Object 2'::VARCHAR));

-- 查询对象列表
SELECT * FROM object_list;