FAQ
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 You

Ramesh Patel
Computer Dept.
Banasdairy, Palanpur

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedApr 28, '04 at 10:27a
activeApr 28, '04 at 10:27a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Ramesh Patel: 1 post

People

Translate

site design / logo © 2022 Grokbase