[Solved] What will be the result of this query?SELECT daterange('2023-01-01', '2023-01-10', '[]') @> '2023-01-10'::date; | PostgreSQL

PostgreSQL - Advanced Features

What will be the result of this query?

SELECT daterange('2023-01-01', '2023-01-10', '[]') @> '2023-01-10'::date;

Afalse

Btrue

Cnull

Dsyntax error

Step-by-Step Solution

Solution:

Step 1: Understand the daterange boundaries
The range is from '2023-01-01' to '2023-01-10' inclusive on both ends because of '[]'.
Step 2: Check if the date is contained
The date '2023-01-10' is included because the upper bound is inclusive.
Final Answer:
true -> Option B
Quick Check:
Inclusive bounds include upper date, so result = true [OK]

Quick Trick: Inclusive bounds '[]' include end date in daterange [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the result of this query?