[Solved] Consider this PL/pgSQL snippet:DECLARE grade CHAR := 'B'; result TEXT; BEGIN CASE grade WHEN 'A' THEN result := 'Excellent'; WHEN 'B' THEN result := 'Good';... END;What will be the returned value? | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Consider this PL/pgSQL snippet:

DECLARE
  grade CHAR := 'B';
  result TEXT;
BEGIN
  CASE grade
    WHEN 'A' THEN result := 'Excellent';
    WHEN 'B' THEN result := 'Good';
    ELSE result := 'Average';
  END CASE;
  RETURN result;
END;

What will be the returned value?

A'Good'

B'Average'

C'Excellent'

DNULL

Step-by-Step Solution

Solution:

Step 1: Identify the value of grade
The variable grade is set to 'B'.
Step 2: Match grade in CASE
CASE checks 'B', matches the second WHEN clause, so result becomes 'Good'.
Final Answer:
'Good' -> Option A
Quick Check:
grade 'B' returns 'Good' [OK]

Quick Trick: Match CASE value to WHEN clause for output [OK]

Common Mistakes:

Choosing ELSE when a WHEN matches
Confusing variable assignment inside CASE
Assuming NULL if no ELSE present

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

Consider this PL/pgSQL snippet:

Step 1: Identify the value of grade

Step 2: Match grade in CASE

Final Answer:

Quick Check:

Want More Practice?