Return value in function/trigger

Поиск
Список
Период
Сортировка
Искать
От
Jean-Christian Imbeault
Тема
Return value in function/trigger
Дата
Msg-id
3DDAF868.3010506@mega-bucks.co.jp
Список
Дерево обсуждения
Re: Return value in function/trigger Jean-Christian Imbeault <jc@mega-bucks.co.jp>
Re: Return value in function/trigger Neil Conway <neilc@samurai.com>
I have created a trigger and the function executed by the trigger. 
However the function merely updates values in a table and doesn't return 
any result/value. what is the correct way of "returning" nothing?

I have written this but using "return new" seems pointless as I don't 
need(?) to return anything.

create or replace function update_invoice_price() returns opaque as '
   begin
     update invoices set total_price=(select sum(price) from invoice_li 
where invoice_id=new.invoice_id) where id=new.invoice_id;
     return new;
   end;
' language 'plpgsql' with (iscachable);

create trigger update_invoice_li_price after update
   on invoice_li for each row
   execute procedure update_invoice_price();

Thanks!

Jc

В списке pgsql-general по дате отправления
От: Charles H. Woloszynski
Дата:
От: Stephan Szabo
Дата:
FAQ