-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de UPDATE: tua_sga_comisiones
-- AFTER UPDATE
-- Tabla: sga_comisiones
-- Version: 3.0.0
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP FUNCTION ftua_sga_comisiones ();
CREATE OR REPLACE FUNCTION ftua_sga_comisiones () RETURNS trigger AS 
$BODY$

BEGIN

   -- Si cambó el cupo entonces cambio el valor en la tabla de cupos
   IF COALESCE(OLD.cupo, 0) <> COALESCE(NEW.cupo, 0) THEN
     UPDATE sga_comisiones_cupo
        SET cupo = COALESCE(NEW.cupo, 0)
      WHERE comision = NEW.comision;
   END IF;
   
   RETURN NEW;
END;
$BODY$
LANGUAGE 'plpgsql';

-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de UPDATE sobre sga_comisiones
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP TRIGGER tua_sga_comisiones ON sga_comisiones RESTRICT;
CREATE TRIGGER tua_sga_comisiones
       AFTER UPDATE ON sga_comisiones
       FOR EACH ROW EXECUTE PROCEDURE ftua_sga_comisiones();