PostgreSQL - PL/pgSQL Fundamentals
In a PL/pgSQL function, you want to raise a notice with a variable and then raise an exception with a custom SQLSTATE code. Which snippet is correct?
In a PL/pgSQL function, you want to raise a notice with a variable and then raise an exception with a custom SQLSTATE code. Which snippet is correct?
hard📝 Application Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Check RAISE NOTICE syntax
RAISE NOTICE uses format string with % and variable as argument, as in RAISE NOTICE 'Current value: %', val; RAISE EXCEPTION USING MESSAGE = 'Custom error', SQLSTATE = 'P0001';.Step 2: Verify RAISE EXCEPTION with SQLSTATE
Correct syntax uses RAISE EXCEPTION USING MESSAGE and SQLSTATE, as in RAISE NOTICE 'Current value: %', val; RAISE EXCEPTION USING MESSAGE = 'Custom error', SQLSTATE = 'P0001';.Step 3: Identify syntax errors in other options
The other three options misuse concatenation, parentheses, or keywords.Final Answer:
RAISE NOTICE 'Current value: %', val; RAISE EXCEPTION USING MESSAGE = 'Custom error', SQLSTATE = 'P0001'; -> Option DQuick Check:
Use USING clause for custom SQLSTATE in RAISE EXCEPTION [OK]
Quick Trick: Use USING MESSAGE and SQLSTATE for custom exceptions [OK]
Common Mistakes:
- Concatenating strings instead of using % placeholders
- Incorrect syntax for SQLSTATE assignment
- Omitting USING keyword
Master "PL/pgSQL Fundamentals" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes