Advertisement
fenix15100

Untitled

Apr 6th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.68 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION aviso() RETURNS TRIGGER AS'
  2.  
  3. DECLARE
  4. tete INTEGER;
  5. BEGIN
  6.  
  7. IF(new.pres_dev=="devuelta") THEN
  8.  
  9.  
  10.     select codsocio min(fecha) into tete,min_fecha from lista_espera where (titulo,nomdirector) in
  11.         (select titulo,nomdirector from cintas where numcinta in(select new.numcinta from prestamos)) group by 1;
  12.    
  13.     RAISE NOTICE ''La peli % ha sido devuelta, se ha enviado un mensaje al socio % para que sepa que
  14.     ya puede alquilarla'',new.numcinta,tete;
  15.    
  16.    
  17. END IF;
  18.  
  19. RETURN NEW;
  20.    
  21.    
  22.    
  23.    
  24.    
  25.  
  26. END;
  27. 'LANGUAGE 'plpgsql';
  28.  
  29. DROP TRIGGER aviso ON prestamo;
  30. CREATE TRIGGER aviso
  31.     AFTER UPDATE ON prestamo
  32.     FOR EACH ROW
  33.     EXECUTE PROCEDURE aviso();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement