[Solved] What will be the output of this DO block?DO $ BEGIN RAISE NOTICE 'Hello, PostgreSQL!'; END $ LANGUAGE plpgsql; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

What will be the output of this DO block?

DO $$
BEGIN
  RAISE NOTICE 'Hello, PostgreSQL!';
END
$$ LANGUAGE plpgsql;

AIt prints 'Hello, PostgreSQL!' as a notice message

BIt returns a result set with 'Hello, PostgreSQL!'

CIt causes a syntax error

DIt creates a permanent function named 'Hello, PostgreSQL!'

Step-by-Step Solution

Solution:

Step 1: Understand RAISE NOTICE in DO blocks
RAISE NOTICE outputs a message to the client as an informational notice, not a query result.
Step 2: Analyze the DO block behavior
The block runs immediately and prints the notice message but does not return rows or create functions.
Final Answer:
It prints 'Hello, PostgreSQL!' as a notice message -> Option A
Quick Check:
RAISE NOTICE outputs messages, not query results [OK]

Quick Trick: RAISE NOTICE shows messages, no query output [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the output of this DO block?