[Solved] Given the table bookings with a daterange column stay, what does this query return?SELECT * FROM bookings WHERE stay && daterange('2024-06-01', '2024-06-10'); | PostgreSQL

PostgreSQL - Advanced Features

Given the table bookings with a daterange column stay, what does this query return?

SELECT * FROM bookings WHERE stay && daterange('2024-06-01', '2024-06-10');

ARows where stay starts exactly on June 1, 2024

BRows where stay is completely inside June 1 to June 10, 2024

CRows where stay ends before June 10, 2024

DRows where stay overlaps with June 1 to June 10, 2024

Step-by-Step Solution

Solution:

Step 1: Understand the operator && for ranges
The && operator checks if two ranges overlap at all.
Step 2: Analyze the query condition
The query selects rows where the stay range overlaps with the range from June 1 to June 10, 2024.
Final Answer:
Rows where stay overlaps with June 1 to June 10, 2024 -> Option D
Quick Check:
Range overlap operator && means any overlap [OK]

Quick Trick: && means any overlap between ranges [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table bookings with a daterange column stay, what does this query return?