如何在postgres函数中使用plpgsql递归返回表？不使用CTE/With Recursive

CREATE OR REPLACE FUNCTION recursive_function()
RETURNS TABLE (id INT, name TEXT) AS $$
DECLARE
    rec RECORD;
BEGIN
    -- 创建临时表用于存储结果
    CREATE TEMPORARY TABLE temp_table (id INT, name TEXT) ON COMMIT DROP;

    -- 递归函数
    CREATE OR REPLACE FUNCTION recursive_func(id INT)
    RETURNS VOID AS $$
    BEGIN
        -- 将当前行插入临时表
        INSERT INTO temp_table SELECT id, name FROM your_table WHERE id = recursive_func.id;

        -- 递归调用
        FOR rec IN SELECT id, name FROM your_table WHERE parent_id = recursive_func.id LOOP
            PERFORM recursive_func(rec.id);
        END LOOP;
    END;
    $$ LANGUAGE plpgsql;

    -- 调用递归函数
    PERFORM recursive_func(0);

    -- 返回临时表中的结果
    RETURN QUERY SELECT * FROM temp_table;
END;
$$ LANGUAGE plpgsql;