[Solved] What will be the output of this function call?CREATE FUNCTION sample() RETURNS SETOF text AS $ BEGIN RETURN NEXT 'apple'; RETURN NEXT 'banana'; RETURN 'cherry'; END; $ LANGUAGE plpgsql;... | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

What will be the output of this function call?

CREATE FUNCTION sample() RETURNS SETOF text AS $$
BEGIN
  RETURN NEXT 'apple';
  RETURN NEXT 'banana';
  RETURN 'cherry';
END;
$$ LANGUAGE plpgsql;

SELECT * FROM sample();

ARows: 'apple', 'banana'

BRow: 'cherry' only

CRows: 'apple', 'banana', 'cherry'

DError: RETURN used after RETURN NEXT

Step-by-Step Solution

Solution:

Step 1: Analyze RETURN NEXT statements
First two RETURN NEXT add 'apple' and 'banana' to output.
Step 2: Analyze RETURN statement
RETURN 'cherry' adds 'cherry' to the output and ends the function.
Final Answer:
All three rows 'apple', 'banana', and 'cherry' are returned -> Option C
Quick Check:
RETURN adds final row and ends function = Rows: 'apple', 'banana', 'cherry' [OK]

Quick Trick: RETURN NEXT adds rows; RETURN adds final row and ends function [OK]

Common Mistakes:

Assuming only 'cherry' is returned
Thinking RETURN after RETURN NEXT ignores previous rows
Expecting error due to RETURN after RETURN NEXT

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

What will be the output of this function call?

Step 1: Analyze RETURN NEXT statements

Step 2: Analyze RETURN statement

Final Answer:

Quick Check:

Want More Practice?