postgresql – postgres中的递归函数

create or replace function recursive_function (ct int,pr int)
returns table (counter int,product int)
language plpgsql
as $$
begin
    return query SELEct ct,pr;
    if ct < 10 then
        return query SELEct * from recursive_function(ct+ 1,pr * (ct+ 1));
    end if;
end $$;

SELEct * from recursive_function (1,1);

循环功能：

create or replace function loop_function ()
returns table (counter int,product int)
language plpgsql
as $$
declare
    ct int;
    pr int = 1;
begin
    for ct in 1..10 loop
        pr = ct* pr;
        return query SELEct ct,pr;
    end loop;
end $$;

SELEct * from loop_function ();