Solution:Step 1: Recognize multiple OUT parametersThe function returns a record with columns 'id' and 'name' set inside the function.Step 2: Understand SELECT * outputSELECT * returns a row with column names and their assigned values.Final Answer:id | 1, name | Alice -> Option BQuick Check:Multiple

[Solved] Given this function:CREATE FUNCTION get_info(OUT id INT, OUT name TEXT) AS $ BEGIN id := 1; name := 'Alice'; END; $ LANGUAGE plpgsql;SELECT * FROM get_info();What will the query return? | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Given this function:

CREATE FUNCTION get_info(OUT id INT, OUT name TEXT) AS $$ BEGIN id := 1; name := 'Alice'; END; $$ LANGUAGE plpgsql;
SELECT * FROM get_info();

What will the query return?

A1 | Alice

Bid | 1, name | Alice

CError: function must return a value

DEmpty result set

Step-by-Step Solution

Solution:

Step 1: Recognize multiple OUT parameters
The function returns a record with columns 'id' and 'name' set inside the function.
Step 2: Understand SELECT * output
SELECT * returns a row with column names and their assigned values.
Final Answer:
id | 1, name | Alice -> Option B
Quick Check:
Multiple OUT parameters return named columns [OK]

Quick Trick: Multiple OUT parameters return a record with named columns [OK]

Common Mistakes:

Expecting unnamed values
Thinking explicit RETURN is required
Assuming error due to no RETURNS clause

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given this function:

Step 1: Recognize multiple OUT parameters

Step 2: Understand SELECT * output

Final Answer:

Quick Check:

Want More Practice?