[Solved] Find the error in this PL/pgSQL function:CREATE FUNCTION faulty_func() RETURNS VOID AS $ BEGIN PERFORM SELECT 1 / 0; END; $ LANGUAGE plpgsql; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Find the error in this PL/pgSQL function:

CREATE FUNCTION faulty_func() RETURNS VOID AS $$
BEGIN
  PERFORM SELECT 1 / 0;
END;
$$ LANGUAGE plpgsql;

APERFORM cannot be used in functions

BMissing RETURN statement

CIncorrect function language declaration

DDivision by zero error at runtime

Step-by-Step Solution

Solution:

Step 1: Analyze the PERFORM statement
PERFORM executes a query but here it attempts division by zero, which causes runtime error.
Step 2: Check other syntax
RETURN is not needed for VOID functions; language declaration and PERFORM usage are correct.
Final Answer:
Division by zero error at runtime -> Option D
Quick Check:
Runtime errors occur on invalid operations like division by zero [OK]

Quick Trick: Watch for runtime errors like division by zero [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the error in this PL/pgSQL function: