为什么我的plpgsql函数没有返回任何行(why does my plpgsql function return no rows)

 当两个查询针对用户独立运行时，我得到结果300和0，但是在我的函数中，我没有返回任何行。 
 
 我正在从SQL Server迁移到PostgresSQL，所以有些事情对我来说有些陌生！ 
 
create or replace function getsummary(userid int)
returns table (assetTotal numeric, liabilityTotal numeric)
as $$
BEGIN

SELECT sum(t.credit) - sum(t.debit)
into assetTotal
    from transactions t
    join user_institutes i on t.user_institute_id = i.id
    where i.account_type in (1,3,4,5)
    and i.user_id = userid;

    select sum(t.credit) - sum(t.debit)
    into liabilityTotal
    from transactions t
    join user_institutes i on t.user_institute_id = i.id
    where i.account_type in (2,8,10)
    and i.user_id = userid;
END
$$ language plpgsql;

select * from getsummary(1)
 
 非常感谢 

when the two queries are run independently against a user I get the results 300 and 0 however in my function I am getting no rows returned.
 
I am moving from SQL Server to PostgresSQL so some things are a bit alien to me!
 
create or replace function getsummary(userid int)
returns table (assetTotal numeric, liabilityTotal numeric)
as $$
BEGIN

SELECT sum(t.credit) - sum(t.debit)
into assetTotal
    from transactions t
    join user_institutes i on t.user_institute_id = i.id
    where i.account_type in (1,3,4,5)
    and i.user_id = userid;

    select sum(t.credit) - sum(t.debit)
    into liabilityTotal
    from transactions t
    join user_institutes i on t.user_institute_id = i.id
    where i.account_type in (2,8,10)
    and i.user_id = userid;
END
$$ language plpgsql;

select * from getsummary(1)
 
Many thanks

原文：https://stackoverflow.com/questions/43824847