db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Boss: room booking

Design a table where the database itself forbids double booking. Adjacent times are fine. Five hidden inserts check it.

task

Create rooms_bk(room int, during tstzrange) so the same room cannot be booked for overlapping times (adjacent times are fine).

hints