[Solved] What is wrong with this code snippet?DECLARE arr integer[] := ARRAY[1,2,3]; val integer; BEGIN FOREACH val LOOP RAISE NOTICE '%', val; END LOOP; END; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

What is wrong with this code snippet?

DECLARE
  arr integer[] := ARRAY[1,2,3];
  val integer;
BEGIN
  FOREACH val LOOP
    RAISE NOTICE '%', val;
  END LOOP;
END;

AVariable val should be text, not integer

BFOREACH missing 'IN ARRAY arr' clause

CRAISE NOTICE cannot print integers

DArray declaration syntax is invalid

Step-by-Step Solution

Solution:

Step 1: Review FOREACH syntax
FOREACH requires specifying the array to iterate over with 'IN ARRAY arr'.
Step 2: Identify missing clause
The code misses 'IN ARRAY arr' after FOREACH val.
Final Answer:
FOREACH missing 'IN ARRAY arr' clause -> Option B
Quick Check:
FOREACH must specify array source [OK]

Quick Trick: FOREACH must include 'IN ARRAY arr' [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this code snippet?