[Solved] Find the error in this FOR loop code:DO $ DECLARE sum INT := 0; BEGIN FOR i IN 1..5 LOOP sum := sum + j; END LOOP; RAISE NOTICE 'Sum: %', sum; END $; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Find the error in this FOR loop code:

DO $$
DECLARE
  sum INT := 0;
BEGIN
  FOR i IN 1..5 LOOP
    sum := sum + j;
  END LOOP;
  RAISE NOTICE 'Sum: %', sum;
END $$;

AVariable j is undefined inside the loop

BFOR loop range is invalid

CRAISE NOTICE syntax is incorrect

Dsum variable should be declared as TEXT

Step-by-Step Solution

Solution:

Step 1: Check variables used inside the loop
The loop variable is i, but the code uses j inside the loop.
Step 2: Identify undefined variable usage
Variable j is not declared or assigned, causing an error.
Final Answer:
Variable j is undefined inside the loop -> Option A
Quick Check:
Use correct loop variable inside FOR loops [OK]

Quick Trick: Use the loop variable name consistently inside the loop [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the error in this FOR loop code: