[Solved] Given a table regions with a polygon column and a GiST index on it, what will the query below return?SELECT * FROM regions WHERE polygon @> '((2,2),(3,3),(4,2),(2,2))'::polygon; | PostgreSQL

PostgreSQL - Indexing Strategies

Given a table regions with a polygon column and a GiST index on it, what will the query below return?

SELECT * FROM regions WHERE polygon @> '((2,2),(3,3),(4,2),(2,2))'::polygon;

AAll rows where the polygon contains the specified polygon

BAll rows where the polygon overlaps with the specified polygon

CAll rows where the polygon is equal to the specified polygon

DAll rows where the polygon is contained within the specified polygon

Step-by-Step Solution

Solution:

Step 1: Understand the operator
The operator @> means "contains" in geometric types.
Step 2: Analyze the query
The query selects rows where the polygon column contains the given polygon.
Final Answer:
All rows where the polygon contains the specified polygon -> Option A
Quick Check:
Operator @> means contains [OK]

Quick Trick: Operator @> means contains for geometric types [OK]

Common Mistakes:

Confusing @> with && (overlaps)
Assuming equality instead of containment
Thinking @> means contained by

Master "Indexing Strategies" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given a table regions with a polygon column and a GiST index on it, what will the query below return?

Step 1: Understand the operator

Step 2: Analyze the query

Final Answer:

Quick Check:

Want More Practice?