CREATE TABLE tbl ( id_medico int , fecha_inicial timestamp , fecha_final timestamp , EXCLUDE USING gist (id_medico WITH =,tsrange(fecha_inicial, fecha_final) WITH &&) -- no overlap ); INSERT INTO tbl (id_medico,fecha_inicial, fecha_final) VALUES (1, '2021-04-22 08:00:00', '2021-04-22 10:00:00') , (1, '2021-04-22 13:00:00 ', '2021-04-22 14:00:00') ;

-- Works INSERT INTO tbl (id_medico,fecha_inicial, fecha_final) VALUES (2,'2021-04-22 08:00:00', '2021-04-22 10:00:00'); TABLE tbl;

-- Fails INSERT INTO tbl (id_medico,fecha_inicial, fecha_final) VALUES (1, '2021-04-22 07:00:00', '2021-04-22 09:00:00');