[Solved] Identify the error in this PL/pgSQL code:DO $ DECLARE val INT := 5; BEGIN IF val > 3 RAISE NOTICE 'Greater than 3'; END IF; END $; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Identify the error in this PL/pgSQL code:

DO $$
DECLARE
  val INT := 5;
BEGIN
  IF val > 3
    RAISE NOTICE 'Greater than 3';
  END IF;
END $$;

AMissing semicolon after RAISE NOTICE

BMissing THEN after IF condition

CIncorrect variable declaration

DEND IF should be ENDIF

Step-by-Step Solution

Solution:

Step 1: Check IF syntax
In PL/pgSQL, IF condition must be followed by THEN.
Step 2: Analyze code
The code misses THEN after IF val > 3, causing syntax error.
Final Answer:
Missing THEN after IF condition -> Option B
Quick Check:
IF requires THEN after condition [OK]

Quick Trick: Always put THEN after IF condition [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 code: