Code :DROP TRIGGER trigOL ON outlaw;
CREATE FUNCTION trigOutlaw_2() RETURNS trigger AS $$
DECLARE
nbol int;
BEGIN
SELECT COUNT(*) INTO nbol FROM outlaw;
RAISE NOTICE '% outlaws dans la table', nbol;
RETURN NEW;
END $$ LANGUAGE plpgsql;
CREATE TRIGGER trigOL
AFTER
INSERT ON outlaw FOR EACH STATEMENT
EXECUTE PROCEDURE trigOutlaw_2();
DELETE FROM outlaw;
INSERT INTO outlaw(ol_nom,ol_prenom,ol_naissance) SELECT etud_nom, etud_prenom, etud_naissance FROM etudiant WHERE etud_nom = 'Dalton';
SELECT * FROM outlaw;