[Solved] What is wrong with this CASE statement?DECLARE val INT := 3; res TEXT; BEGIN CASE WHEN val = 1 THEN res := 'One'; WHEN val = 2 THEN res := 'Two'; ELSE res := 'Other'; END CASE; END; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

What is wrong with this CASE statement?

DECLARE
  val INT := 3;
  res TEXT;
BEGIN
  CASE
    WHEN val = 1 THEN res := 'One';
    WHEN val = 2 THEN res := 'Two';
    ELSE res := 'Other';
END CASE;
END;

AVariable val is not initialized

BCASE must have an expression after it

CELSE clause is not allowed

DMissing semicolon after ELSE assignment

Step-by-Step Solution

Solution:

Step 1: Check syntax of assignments
Each assignment must end with a semicolon.
Step 2: Identify missing semicolon
After ELSE res := 'Other' there is no semicolon, causing error.
Final Answer:
Missing semicolon after ELSE assignment -> Option D
Quick Check:
Semicolons required after each assignment [OK]

Quick Trick: Every assignment inside CASE needs a semicolon [OK]

Common Mistakes:

Omitting semicolon after ELSE
Thinking CASE needs expression always
Confusing ELSE clause usage

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

What is wrong with this CASE statement?

Step 1: Check syntax of assignments

Step 2: Identify missing semicolon

Final Answer:

Quick Check:

Want More Practice?