tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_vw_building_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE tww_od.connection_object SET fk_dataowner = NEW.fk_dataowner , fk_provider = NEW.fk_provider , fk_wastewater_networkelement = NEW.fk_wastewater_networkelement , identifier = NEW.identifier , last_modification = NEW.last_modification , remark = NEW.remark , sewer_infiltration_water_production = NEW.sewer_infiltration_water_production WHERE obj_id = OLD.obj_id; UPDATE tww_od.building SET obj_id = NEW.obj_id , house_number = NEW.house_number , location_name = NEW.location_name , perimeter_geometry = NEW.perimeter_geometry , reference_point_geometry = NEW.reference_point_geometry WHERE obj_id = OLD.obj_id; RETURN NEW; END;