[Solved] How would you modify this function to return only users with IDs greater than 10?CREATE FUNCTION filtered_users() RETURNS TABLE(id INT, name TEXT) AS $ BEGIN RETURN QUERY SELECT id, name FROM users;... | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

How would you modify this function to return only users with IDs greater than 10?

CREATE FUNCTION filtered_users() RETURNS TABLE(id INT, name TEXT) AS $$ BEGIN RETURN QUERY SELECT id, name FROM users; END; $$ LANGUAGE plpgsql;

AAdd IF id > 10 THEN RETURN NEXT id, name; END IF;

BAdd a parameter to the function and filter outside

CChange RETURNS TABLE to RETURNS SETOF RECORD

DAdd WHERE id > 10 in the SELECT inside RETURN QUERY

Step-by-Step Solution

Solution:

Step 1: Understand filtering in RETURN QUERY
To filter rows, add a WHERE clause inside the SELECT statement used in RETURN QUERY.
Step 2: Evaluate other options
Add IF id > 10 THEN RETURN NEXT id, name; END IF; is invalid syntax, C changes return type unnecessarily, and D is a design change, not a direct fix.
Final Answer:
Add WHERE id > 10 in the SELECT inside RETURN QUERY -> Option D
Quick Check:
Filter rows inside RETURN QUERY SELECT with WHERE clause = B [OK]

Quick Trick: Filter rows inside RETURN QUERY SELECT with WHERE clause [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

How would you modify this function to return only users with IDs greater than 10?