Dear Friends,
Postgres 7.3.4 on RH Linux 7.2.
Get the following from the groups
create or replace function ExpensiveDepartments() returns setof table1 as
'
declare r table1%rowtype;
begin for r in select departmentid, sum(salary) as totalsalary from GetEmployees() group by departmentid loop
if (r.totalsalary > 70000) then r.totalsalary := CAST(r.totalsalary * 1.75 as int8); else r.totalsalary := CAST(r.totalsalary * 1.5 as int8); end if;
if (r.totalsalary > 100000) then return next r.departmentid; end if;
end loop; return;
end
'
language 'plpgsql';
Is possible for me to return a variable along with that 'return' statement? Because the table 'table1' contains some date
column. I have done some calculation on those columns and want to return the calculated date along with that row of the
table1. How to do that. Please shed some light.
