[Solved] Find the error in this DO block:DO $ DECLARE msg TEXT; BEGIN msg := 'Hello'; RAISE NOTICE msg; END $; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Find the error in this DO block:

DO $$
DECLARE
  msg TEXT;
BEGIN
  msg := 'Hello';
  RAISE NOTICE msg;
END
$$;

AMissing semicolon after RAISE NOTICE

BVariable msg not declared

CRAISE NOTICE requires a format string with % placeholders

DDO blocks cannot use RAISE NOTICE

Step-by-Step Solution

Solution:

Step 1: Check RAISE NOTICE syntax
RAISE NOTICE expects a format string with % placeholders for variables.
Step 2: Identify missing format string
Here, msg is passed directly without format string, causing error.
Final Answer:
RAISE NOTICE requires a format string with % placeholders -> Option C
Quick Check:
RAISE NOTICE syntax = format string needed [OK]

Quick Trick: Use RAISE NOTICE 'text %', var; format [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the error in this DO block: