overlaps()

1create table
2issues (
3  id int8 primary key,
4  title text,
5  tags text[]
6);
7
8insert into
9issues (id, title, tags)
10values
11(1, 'Cache invalidation is not working', array['is:open', 'severity:high', 'priority:low']),
12(2, 'Use better names', array['is:open', 'severity:low', 'priority:medium']);

1                                                                              
2create table
3reservations (
4  id int8 primary key,
5  room_name text,
6  during tsrange
7);
8
9insert into
10reservations (id, room_name, during)
11values
12(1, 'Emerald', '[2000-01-01 13:00, 2000-01-01 15:00)'),
13(2, 'Topaz', '[2000-01-02 09:00, 2000-01-02 10:00)');