I dont know the error with updtae

[Edwin Quijada]

Hi!
I have a trigger using a update but this doestn work into trigger but if I
execute the update from pgadmin this works perfectely.

This is the code
select into registro * from t_pagos_comisio nes where f_wholetipoagni vel =
who and f_fecha = $4 for update;
IF FOUND THEN
IF ($5 >0) THEN
t1:= registro.f_mont opagado+$7;
t2:= registro.f_mont ocomision+$5;
raise notice '' hacer el update t1 y t2 %, %'',t1,t2;
--f_montocomision =t2
UPDATE t_pagos_comisio nes SET
f_montopagado=t 1,f_montocomisi on=t2,f_nivel=9 0 where f_wholetipoagni vel
= who and f_fecha = vfecha;
end if;
end if;

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

_______________ _______________ _______________ _______________ _____
¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster