[Solved] Find the problem in this function:CREATE FUNCTION test() RETURNS SETOF int AS $ DECLARE i int := 1; BEGIN WHILE i | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Find the problem in this function:

CREATE FUNCTION test() RETURNS SETOF int AS $$
DECLARE
  i int := 1;
BEGIN
  WHILE i <= 3 LOOP
    RETURN NEXT i;
  END LOOP;
  RETURN;
END;
$$ LANGUAGE plpgsql;

AMissing RETURN statement at the end.

BFunction should return TABLE, not SETOF int.

CRETURN NEXT cannot be used inside loops.

DInfinite loop because variable i is never incremented.

Step-by-Step Solution

Solution:

Step 1: Check loop control variable
Variable i is initialized but never incremented inside the loop.
Step 2: Consequence of no increment
Loop condition i <= 3 is always true, causing infinite loop.
Final Answer:
Infinite loop due to missing increment of i -> Option D
Quick Check:
Loop variable not updated causes infinite loop = Infinite loop because variable i is never incremented. [OK]

Quick Trick: Always update loop variable to avoid infinite loops [OK]

Common Mistakes:

Assuming RETURN NEXT causes loop exit
Thinking RETURN needed after RETURN NEXT inside loop
Confusing RETURNS SETOF with RETURNS TABLE

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

Find the problem in this function:

Step 1: Check loop control variable

Step 2: Consequence of no increment

Final Answer:

Quick Check:

Want More Practice?