gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
v_portion_update
Description
Effectue les mises à jour dans la table portion lors de la saisie dans la vue v_portion
Parameters
Name
Type
Mode
Definition
BEGIN UPDATE veloroutes.portion SET nom = NEW.nom, description = NEW.description, type_portion = NEW.type_portion, id_on3v = NEW.id_on3v, id_local = NEW.id_local, mont_subv = NEW.mont_subv, annee_subv = NEW.annee_subv, convention = NEW.convention, type_pluriannuel = NEW.type_pluriannuel WHERE id_portion = OLD.id_portion; RETURN NEW; END;