Hi
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


Ramesh Patel
Computer Dept.
Banasdairy, Palanpur