[Solved] You wrote this query to find bookings fully inside June 2024:SELECT * FROM bookings WHERE stay But it returns no rows even though some bookings are inside June. What is the likely problem? | PostgreSQL

PostgreSQL - Advanced Features

You wrote this query to find bookings fully inside June 2024:

SELECT * FROM bookings WHERE stay <@ daterange('2024-06-01', '2024-06-30');

But it returns no rows even though some bookings are inside June. What is the likely problem?

AThe <code>daterange</code> upper bound is exclusive by default, so '2024-06-30' is not included

BThe <code><@</code> operator checks for overlap, not containment

CThe <code>stay</code> column is not of type <code>daterange</code>

DThe query syntax is invalid and causes an error

Step-by-Step Solution

Solution:

Step 1: Understand <@ operator meaning
<@ means the left range is fully contained inside the right range.
Step 2: Check daterange bounds behavior
By default, daterange upper bound is exclusive, so '2024-06-30' is not included in the range. This excludes bookings on June 30.
Final Answer:
The daterange upper bound is exclusive by default, so '2024-06-30' is not included -> Option A
Quick Check:
Upper bound exclusive means end date not included [OK]

Quick Trick: Remember daterange upper bound is exclusive by default [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You wrote this query to find bookings fully inside June 2024: