i have one problem in Trigger.

this trigger alread work on Red Hat Linux 7.3 but now i shift to RHL9.0

in 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'

BEGIN

UPDATE 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_cs

WHERE rcpt_detail.batch_code = NEW.batch_code

and rcpt_detail.mtrl_code = NEW.mtrl_code

and rcpt_detail.loc_code = NEW.loc_code;

return NULL;

END;'

language 'plpgsql';

/////////////////////////// Function End //////////////////////////////////////////

/////////////////////////// Trigger Start //////////////////////////////////////////

CREATE TRIGGER add_issue_trg

AFTER INSERT ON issue_detail

FOR EACH ROW EXECUTE PROCEDURE add_issue_fun();

/////////////////////////// Trigger End //////////////////////////////////////////

Thanking You

Ramesh Patel
Computer Dept.
Banasdairy, Palanpur