[Solved] What does a PostgreSQL function declared with RETURNS TABLE do? — Ans: Returns multiple rows and columns as a table result | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

What does a PostgreSQL function declared with RETURNS TABLE do?

AReturns no result, only performs actions

BReturns only a single scalar value

CReturns multiple rows and columns as a table result

DReturns a JSON object

Step-by-Step Solution

Solution:

Step 1: Understand the purpose of RETURNS TABLE
The RETURNS TABLE clause defines that the function will return a set of rows with specified columns, like a table.
Step 2: Compare with other return types
Unlike scalar returns or void, RETURNS TABLE returns multiple rows and columns.
Final Answer:
Returns multiple rows and columns as a table result -> Option C
Quick Check:
RETURNS TABLE means multiple rows/columns [OK]

Quick Trick: RETURNS TABLE means function outputs rows and columns [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does a PostgreSQL function declared with RETURNS TABLE do?