tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_prank_weir_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.prank_weir SET obj_id = NEW.obj_id , hydraulic_overflow_length = NEW.hydraulic_overflow_length , level_max = NEW.level_max , level_min = NEW.level_min , weir_edge = NEW.weir_edge , weir_kind = NEW.weir_kind WHERE obj_id = OLD.obj_id; RETURN NEW; END;