create table film_screenings (
id serial primary key,
screening_time tstzrange, -- дата и время начала сеанса
constraint no_screening_time_overlap exclude using gist (
screening_time WITH && -- check for overlapping ranges
)
);
insert into film_screenings (screening_time) values ('["2023-01-01 19:00:00", "2023-01-01 20:45:00"]');