CREATE OR REPLACE FUNCTION meta.master_plan_obj_composition_view()
  RETURNS trigger AS
$BODY$
DECLARE 
v text;
v2 text;

	BEGIN
	IF TG_OP='UPDATE' THEN

	FOR v IN (SELECT  doc_code   FROM meta.dc_planing_doc_sets_catalog)  LOOP

	IF (EXISTS (select * from meta.master_plan_obj_composition where doc_code="v" and class_loc_code=new.class_loc_code ) )
	and (new."v2" is not NULL or new."v2"  not in (0)) THEN
	UPDATE meta.master_plan_obj_composition  set (class_status)=(new."v2" ::integer)
where doc_code="v"  and class_loc_code=new.class_loc_code;end if;
	IF (NOT EXISTS (select * from meta.master_plan_obj_composition where doc_code="v"  and class_loc_code=new.class_loc_code ))  and 
 (new."v2" is not NULL or new."v2"  <>0)
	THEN
	INSERT INTO meta.master_plan_obj_composition( doc_code,  class_loc_code,class_status)
	VALUES ("v" ,new.class_loc_code,new.sh1 ); end if;


END LOOP;
	
	END IF;	

  return new      ;

	END;

$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 1000;