[Solved] Why does this query fail?SELECT * FROM periods WHERE int_range — Ans: int4range('1,10') is invalid syntax; use int4range('[1,10)') | PostgreSQL

PostgreSQL - Advanced Features

Why does this query fail?

SELECT * FROM periods WHERE int_range <@ int4range('1,10');

Aint4range requires string input, not integers

Bint4range('1,10') is invalid syntax; use int4range('[1,10)')

Cint_range column is not a range type

DThe <@ operator is used incorrectly here

Step-by-Step Solution

Solution:

Step 1: Check int4range constructor syntax
The int4range(text) constructor expects a properly formatted string like '[1,10)', but '1,10' lacks bounds notation.
Step 2: Correct usage
Use int4range('[1,10)') or int4range(1,10).
Final Answer:
int4range('1,10') is invalid syntax; use int4range('[1,10)') -> Option B
Quick Check:
Range string needs bounds notation [OK]

Quick Trick: Construct ranges with string notation, not separate numbers [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this query fail?