[Solved] What is wrong with this writable CTE query?WITH deleted AS (DELETE FROM orders WHERE id = 10) SELECT * FROM deleted; | PostgreSQL

PostgreSQL - Common Table Expressions

What is wrong with this writable CTE query?

WITH deleted AS (DELETE FROM orders WHERE id = 10) SELECT * FROM deleted;

AMissing RETURNING clause in DELETE

BDELETE cannot be used in CTE

CSELECT * FROM deleted should be inside DELETE

DCTE name 'deleted' is a reserved keyword

Step-by-Step Solution

Solution:

Step 1: Check DELETE inside writable CTE
DELETE inside CTE must include RETURNING to output deleted rows.
Step 2: Identify missing RETURNING
Without RETURNING, the CTE returns no rows, causing an error or empty result.
Final Answer:
Missing RETURNING clause in DELETE -> Option A
Quick Check:
Writable CTE DELETE needs RETURNING [OK]

Quick Trick: Add RETURNING to DELETE in writable CTE [OK]

Common Mistakes:

Master "Common Table Expressions" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this writable CTE query?