[Solved] Consider this PL/pgSQL function:CREATE OR REPLACE FUNCTION test_return() RETURNS INTEGER AS $ DECLARE val INTEGER := 5; BEGIN IF val > 3 THEN RETURN val * 2; ELSE RETURN val / 2; END IF; END;... | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Consider this PL/pgSQL function:

CREATE OR REPLACE FUNCTION test_return() RETURNS INTEGER AS $$
DECLARE
  val INTEGER := 5;
BEGIN
  IF val > 3 THEN
    RETURN val * 2;
  ELSE
    RETURN val / 2;
  END IF;
END;
$$ LANGUAGE plpgsql;

What will SELECT test_return(); return?

A10

B2

C5

DNULL

Step-by-Step Solution

Solution:

Step 1: Evaluate the IF condition
val is 5, which is greater than 3, so the IF branch executes.
Step 2: Calculate the RETURN value
RETURN val * 2 = 5 * 2 = 10.
Final Answer:
10 -> Option A
Quick Check:
Function returns doubled val when val > 3 [OK]

Quick Trick: Check IF conditions carefully to predict return values [OK]

Common Mistakes:

Returning val instead of val * 2
Confusing ELSE branch output
Assuming NULL return

Master "Advanced PL/pgSQL" 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 function:

Step 1: Evaluate the IF condition

Step 2: Calculate the RETURN value

Final Answer:

Quick Check:

Want More Practice?