Which of the following PostgreSQL function snippets correctly returns multiple rows using RETURN NEXT?

easy📝 Syntax Q3 of 15

PostgreSQL - PL/pgSQL Fundamentals

Which of the following PostgreSQL function snippets correctly returns multiple rows using RETURN NEXT?

ABEGIN RETURN 1; RETURN 2; RETURN; END;

BBEGIN RETURN NEXT 1; RETURN NEXT 2; RETURN; END;

CBEGIN RETURN NEXT 1, 2; RETURN; END;

DBEGIN RETURN 1, 2; RETURN; END;

Step-by-Step Solution

Solution:

Step 1: Understand RETURN NEXT usage
RETURN NEXT adds a single row to the result set.
Step 2: Check each snippet
BEGIN RETURN NEXT 1; RETURN NEXT 2; RETURN; END; uses RETURN NEXT twice to add two rows, then RETURN to finish.
Final Answer:
BEGIN RETURN NEXT 1; RETURN NEXT 2; RETURN; END; correctly returns multiple rows.
Quick Check:
Multiple RETURN NEXT calls add rows sequentially [OK]

Quick Trick: Use RETURN NEXT for each row, then RETURN to end [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free