PostgreSQL - Advanced PL/pgSQL
Which SQL command is used inside a PostgreSQL function returning SETOF to return each row?
Which SQL command is used inside a PostgreSQL function returning SETOF to return each row?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Recall how to return rows one by one
In a function returning SETOF, RETURN NEXT adds one row to the result set.Step 2: Check other options
RETURN QUERY returns a whole query result, RETURN ROW and RETURN ALL are invalid commands.Final Answer:
RETURN NEXT -> Option CQuick Check:
RETURN NEXT adds one row in SETOF functions [OK]
Quick Trick: Use RETURN NEXT to add rows one at a time [OK]
Common Mistakes:
- Using RETURN ROW which is not valid
- Confusing RETURN NEXT with RETURN QUERY
- Trying RETURN ALL which does not exist
Master "Advanced PL/pgSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes