[Solved] What will be the output of the following PostgreSQL block?DO $ BEGIN RAISE EXCEPTION 'Error happened'; EXCEPTION WHEN OTHERS THEN RAISE NOTICE 'Caught an error'; END $; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

What will be the output of the following PostgreSQL block?

DO $$
BEGIN
  RAISE EXCEPTION 'Error happened';
EXCEPTION
  WHEN OTHERS THEN
    RAISE NOTICE 'Caught an error';
END $$;

AThe block raises an error and stops execution

BIt prints 'Caught an error' as a notice and continues

CIt prints 'Error happened' as a notice

DSyntax error due to missing semicolon

Step-by-Step Solution

Solution:

Step 1: Analyze the RAISE EXCEPTION statement
The block raises an exception with message 'Error happened'.
Step 2: Check the EXCEPTION block handling
The exception handler catches all errors (WHEN OTHERS) and raises a NOTICE with 'Caught an error'.
Final Answer:
It prints 'Caught an error' as a notice and continues -> Option B
Quick Check:
Exception caught triggers NOTICE message [OK]

Quick Trick: WHEN OTHERS catches all errors and can raise NOTICE [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the output of the following PostgreSQL block?