create temp table intr (
  id int primary key,
  t time,
  i interval
);
insert into intr values ( 1 , '00:00', '1 hour');
insert into intr values ( 2 , '00:30', '2 hour');
insert into intr values ( 3 , '14:00', '1 hour');
insert into intr values ( 4 , '15:00', '1 hour');
insert into intr values ( 5 , '14:10', '10 min');

select *
from
  intr a
  join intr b on (b.t, b.i) OVERLAPS (a.t, a.i) and b.id>a.id
order by a.t, b.t;

id  t         i         id_1   t_1       i_1
-------------------------------------------------
 1     00 : 00 : 00    01 : 00 : 00    2        00 : 30 : 00    02 : 00 : 00 
 3     14 : 00 : 00    01 : 00 : 00    5        14 : 10 : 00    00 : 10 : 00