tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_leapingweir_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.leapingweir SET obj_id = NEW.obj_id , length = NEW.length , opening_shape = NEW.opening_shape , width = NEW.width WHERE obj_id = OLD.obj_id; RETURN NEW; END;