[Solved] Identify the error in this function:CREATE FUNCTION get_data() RETURNS TABLE(id INT, val TEXT) AS $ BEGIN RETURN SELECT 1, 'a'; END; $ LANGUAGE plpgsql; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Identify the error in this function:

CREATE FUNCTION get_data() RETURNS TABLE(id INT, val TEXT) AS $$ BEGIN RETURN SELECT 1, 'a'; END; $$ LANGUAGE plpgsql;

AMissing RETURN QUERY before SELECT

BWrong column types in RETURNS TABLE

CFunction must return VOID

DMissing LANGUAGE declaration

Step-by-Step Solution

Solution:

Step 1: Check RETURN statement in RETURNS TABLE function
In PL/pgSQL, to return rows from a query, use RETURN QUERY, not just RETURN.
Step 2: Identify missing RETURN QUERY
The function uses RETURN SELECT which is invalid syntax; it should be RETURN QUERY SELECT.
Final Answer:
Missing RETURN QUERY before SELECT -> Option A
Quick Check:
Use RETURN QUERY to return rows in RETURNS TABLE [OK]

Quick Trick: Use RETURN QUERY, not RETURN, to return table rows [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this function: