[Solved] Identify the error in this PL/pgSQL snippet:DECLARE arr text[] := ARRAY['a', 'b', 'c']; ch text; BEGIN FOREACH ch IN arr LOOP RAISE NOTICE '%', ch; END LOOP; END; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Identify the error in this PL/pgSQL snippet:

DECLARE
  arr text[] := ARRAY['a', 'b', 'c'];
  ch text;
BEGIN
  FOREACH ch IN arr LOOP
    RAISE NOTICE '%', ch;
  END LOOP;
END;

AVariable 'ch' must be declared as integer, not text.

BArray declaration syntax is incorrect.

CRAISE NOTICE cannot print variables inside loops.

DFOREACH must use 'IN ARRAY' before the array variable.

Step-by-Step Solution

Solution:

Step 1: Check FOREACH syntax
FOREACH requires 'IN ARRAY' before the array variable to iterate properly.
Step 2: Identify the error
The code uses 'IN arr' instead of 'IN ARRAY arr', causing syntax error.
Final Answer:
FOREACH must use 'IN ARRAY' before the array variable. -> Option D
Quick Check:
FOREACH ... IN ARRAY ... is correct syntax [OK]

Quick Trick: Always write 'FOREACH var IN ARRAY arr' [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this PL/pgSQL snippet: