Hii have one problem in Trigger.this trigger alread work
on Red Hat Linux 7.3 but now i shift to RHL9.0in RHL 9.0 not
working . in this problem in ROUND function.but how to i slove this
i dont know. so please help me.This is Function and
Trigger./////////////////////////// Function Start
//////////////////////////////////////////CREATE
FUNCTION add_issue_fun() returns opaque as'BEGINUPDATE
mtrl_mst set balstk_cs = balstk_cs -
NEW.issueqty_cs,balstk_mt = round( cast((balstk_mt -
NEW.issueqty_mt) as numeric ),4)where mtrl_mst.mtrl_code =
NEW.mtrl_code;UPDATE rcpt_detail set consqty_cs=consqty_cs +
NEW.issueqty_csWHERE rcpt_detail.batch_code = NEW.batch_code
and rcpt_detail.mtrl_code = NEW.mtrl_codeand
rcpt_detail.loc_code = NEW.loc_code;return
NULL;END;'language 'plpgsql';
/////////////////////////// Function End
/////////////////////////////////////////////////////////////////////
Trigger Start //////////////////////////////////////////CREATE
TRIGGER add_issue_trgAFTER INSERT ON issue_detailFOR EACH
ROW EXECUTE PROCEDURE add_issue_fun();
/////////////////////////// Trigger End
//////////////////////////////////////////Thanking
YouRamesh Patel Computer Dept. Banasdairy,
Palanpur
