tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_pump_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.overflow SET actuation = NEW.actuation , adjustability = NEW.adjustability , brand = NEW.brand , control = NEW.control , discharge_point = NEW.discharge_point , fk_control_center = NEW.fk_control_center , fk_dataowner = NEW.fk_dataowner , fk_overflow_char = NEW.fk_overflow_char , fk_overflow_to = NEW.fk_overflow_to , fk_provider = NEW.fk_provider , fk_wastewater_node = NEW.fk_wastewater_node , function = NEW.function , gross_costs = NEW.gross_costs , identifier = NEW.identifier , last_modification = NEW.last_modification , qon_dim = NEW.qon_dim , remark = NEW.remark , signal_transmission = NEW.signal_transmission , subsidies = NEW.subsidies WHERE obj_id = OLD.obj_id; UPDATE tww_od.pump SET obj_id = NEW.obj_id , construction_type = NEW.construction_type , operating_point = NEW.operating_point , placement_of_actuation = NEW.placement_of_actuation , placement_of_pump = NEW.placement_of_pump , pump_flow_max_single = NEW.pump_flow_max_single , pump_flow_min_single = NEW.pump_flow_min_single , start_level = NEW.start_level , stop_level = NEW.stop_level WHERE obj_id = OLD.obj_id; RETURN NEW; END;