What is the primary advantage of using a PostgreSQL function with RETURNS TABLE compared to returning a single scalar value?

easy📝 Conceptual Q1 of 15

PostgreSQL - Advanced PL/pgSQL

What is the primary advantage of using a PostgreSQL function with RETURNS TABLE compared to returning a single scalar value?

AIt allows returning multiple rows and columns as a result set.

BIt improves the function execution speed significantly.

CIt automatically creates indexes on the returned data.

DIt restricts the function to return only one row.

Step-by-Step Solution

Solution:

Step 1: Understand RETURNS TABLE
Functions declared with RETURNS TABLE return a set of rows with defined columns.
Step 2: Compare with scalar returns
Scalar functions return a single value, while RETURNS TABLE returns multiple rows and columns.
Final Answer:
It allows returning multiple rows and columns as a result set. -> Option A
Quick Check:
RETURNS TABLE returns sets, not single values. [OK]

Quick Trick: RETURNS TABLE returns multiple rows and columns [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free