[Solved] Consider this PostgreSQL code snippet inside a function:IF score >= 90 THEN result := 'A';... END IF;If score is 85, what will be the value of result after execution? | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Consider this PostgreSQL code snippet inside a function:

IF score >= 90 THEN
  result := 'A';
ELSIF score >= 80 THEN
  result := 'B';
ELSIF score >= 70 THEN
  result := 'C';
ELSE
  result := 'F';
END IF;

If score is 85, what will be the value of result after execution?

A'A'

B'F'

C'C'

D'B'

Step-by-Step Solution

Solution:

Step 1: Evaluate conditions in order for score = 85
Check if 85 >= 90? No. Then check 85 >= 80? Yes.
Step 2: Assign result based on first true condition
Since 85 >= 80 is true, result is set to 'B'. Remaining conditions are skipped.
Final Answer:
'B' -> Option D
Quick Check:
85 >= 80 = true, so result = 'B' [OK]

Quick Trick: Check conditions top to bottom; first true sets the result [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Consider this PostgreSQL code snippet inside a function: