Return more than a record

Поиск
Список
Период
Сортировка
От Kumar
Тема Return more than a record
Дата
Msg-id 036901c3fc6f$a9159840$7502a8c0@hdsc.com
обсуждение исходный текст
Ответы Re: Return more than a record  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-sql
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.

В списке pgsql-sql по дате отправления:

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: updating remote database
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: Field list from table