[Solved] Identify the error in this recursive CTE:WITH RECURSIVE cte AS ( SELECT id FROM nodes WHERE id = 1 UNION ALL SELECT id + 1 FROM cte WHERE id | PostgreSQL

PostgreSQL - Common Table Expressions

Identify the error in this recursive CTE:

WITH RECURSIVE cte AS ( SELECT id FROM nodes WHERE id = 1 UNION ALL SELECT id + 1 FROM cte WHERE id < 5 ) SELECT * FROM cte;

AAnchor member has no WHERE clause

BMissing UNION ALL keyword

CRecursive member increments id incorrectly

DThe recursive member references 'id' without table alias

Step-by-Step Solution

Solution:

Step 1: Check recursive member references
The recursive member uses 'id' but does not specify which table it comes from.
Step 2: Identify missing alias
It should reference 'cte.id' to avoid ambiguity.
Final Answer:
The recursive member references 'id' without table alias -> Option D
Quick Check:
Recursive member must alias columns from CTE [OK]

Quick Trick: Always alias recursive member columns from CTE [OK]

Common Mistakes:

Master "Common Table Expressions" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this recursive CTE: