trigger after with cursor

Поиск
Список
Период
Сортировка
От betty
Тема trigger after with cursor
Дата
Msg-id b2pphu$2n75$1@news.hub.org
обсуждение исходный текст
Список pgsql-sql
Hi..

I try trigger after insert used cursor without rowtype or cursor with
rowtype, etc:

create or replace function fn_tr_ai_pdcblc() returns trigger as '
declare  c_pdcblc cursor for select * from t_pdcblc where fc_branch=new.fc_branch
and fc_bankacct=new.fc_bankacct;  row_pdcblc t_pdcblc%rowtype;  balance decimal(30,5);
begin   balance:=0;   open c_pdcblc;   for c_pdc in 1..(select count(*) from t_pdcblc where
fc_branch=new.fc_branch and fc_bankacct=new.fc_bankacct and
fd_trxdate>=new.fd_trxdate) loop       fetch c_pdcblc into row_pdcblc;       if (select count(*) from t_pdcblc where
fc_branch=new.fc_branchand
 
fc_bankacct=new.fc_bankacct and fd_trxdate<new.fd_trxdate)>0 then          balance:=fm_balance from t_pdcblc where
fc_branch=new.fc_branch
and fc_bankacct=new.fc_bankacct and fd_trxdate<new.fd_trxdate;       end if;       new.fm_balance :=
balance+row_pdcblc.fm_masuk-row_pdcblc.fm_keluar;
(update field fm_balance at table t_pdcblc)       balance              := new.fm_balance;   end loop;   close c_pdcblc;
 return new;
 
end;' language 'plpgsql';

create trigger tr_ai_pdcblc after insert on d_transaksi.t_pdcblc for each
row execute procedure fn_tr_ai_pdcblc();

result actually:
table t_pdcblc for field fm_balance occupied value null, ex:
fm_masuk        fm_keluar           fm_balance
1000               0

this must:
fm_masuk        fm_keluar           fm_balance
1000               0                        1000


Please help me...

thanks
betty







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

Предыдущее
От: "betty"
Дата:
Сообщение: Re: trigger after with cursor
Следующее
От: Dave Gomboc
Дата:
Сообщение: select from update from select?