postgreSQL - Checking if one date interval does not overlap a date interval in array of intervals for each row
Why don’t you use second table “rooms_reservations” with period of data reservation? It’s more easy and faster with big data.