-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de UPDATE: tua_sga_subcomisiones
-- AFTER UPDATE
-- Tabla: sga_subcomisiones
-- Version: 3.0.0
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

BEGIN

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

-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de UPDATE sobre sga_subcomisiones
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP TRIGGER tua_sga_subcomisiones ON sga_subcomisiones RESTRICT;
CREATE TRIGGER tua_sga_subcomisiones
       AFTER UPDATE ON sga_subcomisiones
       FOR EACH ROW EXECUTE PROCEDURE ftua_sga_subcomisiones();