Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION aviso() RETURNS TRIGGER AS'
- DECLARE
- tete INTEGER;
- BEGIN
- IF(new.pres_dev=="devuelta") THEN
- select codsocio min(fecha) into tete,min_fecha from lista_espera where (titulo,nomdirector) in
- (select titulo,nomdirector from cintas where numcinta in(select new.numcinta from prestamos)) group by 1;
- RAISE NOTICE ''La peli % ha sido devuelta, se ha enviado un mensaje al socio % para que sepa que
- ya puede alquilarla'',new.numcinta,tete;
- END IF;
- RETURN NEW;
- END;
- 'LANGUAGE 'plpgsql';
- DROP TRIGGER aviso ON prestamo;
- CREATE TRIGGER aviso
- AFTER UPDATE ON prestamo
- FOR EACH ROW
- EXECUTE PROCEDURE aviso();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement