[Solved] Identify the issue in this function:CREATE FUNCTION faulty_func() RETURNS TABLE(num INT) AS $ BEGIN RETURN 5; END; $ LANGUAGE plpgsql; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Identify the issue in this function:

CREATE FUNCTION faulty_func() RETURNS TABLE(num INT) AS $$ BEGIN RETURN 5; END; $$ LANGUAGE plpgsql;

ARETURN must be replaced with RETURN QUERY or RETURN NEXT for table functions.

BThe RETURNS TABLE clause is invalid for scalar returns.

CThe function must use RETURNS SETOF INT instead of RETURNS TABLE.

DThe function should not have a BEGIN-END block.

Step-by-Step Solution

Solution:

Step 1: Understand RETURN usage
Functions returning TABLE must use RETURN QUERY or RETURN NEXT to return rows.
Step 2: Analyze the function
This function uses RETURN with a scalar value, which is invalid.
Step 3: Correct approach
Use RETURN QUERY SELECT 5; or RETURN NEXT 5; inside the function.
Final Answer:
RETURN must be replaced with RETURN QUERY or RETURN NEXT for table functions. -> Option A
Quick Check:
RETURN QUERY returns sets, RETURN returns scalar. [OK]

Quick Trick: Use RETURN QUERY or RETURN NEXT in table functions [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the issue in this function: