create function SqlDepartmentSalaries() returns setof holder as
'

select departmentid, sum(salary) as totalsalary from GetEmployees() group by departmentid
'
language 'sql';

create or replace function PLpgSQLDepartmentSalaries() returns setof holder as
'
declare

r holder%rowtype;
begin

for r in select departmentid, sum(salary) as totalsalary from GetEmployees() group by departmentid loop

return next r;
end loop;
return;
end
'
language 'plpgsql';