-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT * FROM PROFESSOR;

SELECT * FROM CURSO;

SELECT * FROM MODULO;
SELECT * FROM PRE_REQUESITO;


INSERT INTO PROFESSOR VALUES (1, 'PROFS', '123456', '1998-08-08', 'OPROFS321@GMAIL.COM', '123', 10000, '2000-01-01');

INSERT INTO CURSO VALUES (1, 'CURSO', 'CURSO CURSO', 1000, 200, 15, TRUE, TRUE, 1);

INSERT INTO MODULO VALUES (1, 'MATEMATICA', 'DESCRICAO', 100, 1);
INSERT INTO MODULO VALUES (2, 'PORTUGUES', 'DESCRICAO', 120, 1);
INSERT INTO MODULO VALUES (3, 'CIENCIAS', 'DESCRICAO', 150, 1);
INSERT INTO MODULO VALUES (4, 'HISTORIA', 'DESCRICAO', 50, 1);
INSERT INTO MODULO VALUES (5, 'GEOGRAFIA', 'DESCRICAO', 180, 1);


CREATE FUNCTION EVENTO_INSERT_MODULO()
RETURNS TRIGGER
AS $$
BEGIN

END
$$ LANGUAGE plpgsql

CREATE TRIGGER TRIGGER_MODULO
BEFORE INSERT
ON MODULO FOR EACH ROW
EXECUTE PROCEDURE EVENTO_INSERT_MODULO()


-- VERIFICAR SE O VALOR TA NA LISTA
SELECT 1 = ANY ('{1,2,3}'::int[])