[Solved] You wrote this function:CREATE FUNCTION test_func() RETURNS SETOF integer AS $ DECLARE i integer := 1; BEGIN RETURN i;... $ LANGUAGE plpgsql;What is the problem with this function? | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

You wrote this function:

CREATE FUNCTION test_func() RETURNS SETOF integer AS $$
DECLARE
  i integer := 1;
BEGIN
  RETURN i;
  RETURN NEXT i + 1;
END;
$$ LANGUAGE plpgsql;

What is the problem with this function?

ARETURN NEXT is used after RETURN, so it never executes.

BRETURN cannot be used in functions returning SETOF.

CVariable i is not initialized properly.

DFunction lacks a LOOP to return multiple rows.

Step-by-Step Solution

Solution:

Step 1: Check order of RETURN and RETURN NEXT
RETURN immediately ends the function, so RETURN NEXT after it never runs.
Step 2: Understand function behavior
Because RETURN is first, only one row is returned and the rest is ignored.
Final Answer:
RETURN NEXT is used after RETURN, so it never executes. -> Option A
Quick Check:
RETURN stops function; code after it is skipped [OK]

Quick Trick: RETURN stops function; code after it won't run [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You wrote this function: