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_comisiones where f_wholetipoagnivel =
who and f_fecha = $4 for update;
IF FOUND THEN
IF ($5 >0) THEN
t1:= registro.f_montopagado+$7;
t2:= registro.f_montocomision+$5;
raise notice '' hacer el update t1 y t2 %, %'',t1,t2;
--f_montocomision=t2
UPDATE t_pagos_comisiones SET
f_montopagado=t1,f_montocomision=t2,f_nivel=90 where f_wholetipoagnivel
= 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