Question

You want to create a function that returns both the count of rows and the maximum value from a table using OUT parameters. Which function definition is correct?

Accepted Answer

CREATE FUNCTION stats(OUT row_count INT, OUT max_val INT) AS $$ BEGIN SELECT COUNT(*), MAX(value) INTO row_count, max_val FROM my_table; END; $$ LANGUAGE plpgsql;

Answer

CREATE FUNCTION stats() RETURNS TABLE(row_count INT, max_val INT) AS $$ BEGIN SELECT COUNT(*), MAX(value) FROM my_table; END; $$ LANGUAGE plpgsql;

Answer

CREATE FUNCTION stats(OUT row_count INT, OUT max_val INT) RETURNS VOID AS $$ BEGIN SELECT COUNT(*), MAX(value) INTO row_count, max_val FROM my_table; END; $$ LANGUAGE plpgsql;

Answer

CREATE FUNCTION stats(row_count INT OUT, max_val INT OUT) RETURNS RECORD AS $$ BEGIN SELECT COUNT(*), MAX(value) INTO row_count, max_val FROM my_table; END; $$ LANGUAGE plpgsql;

You want to create a function that returns both the count of rows and the maximum value from a table using OUT parameters. Which function definition is correct?

Step 1: Check OUT parameter declaration

Step 2: Verify SELECT INTO usage

Step 3: Confirm RETURNS clause

Final Answer:

Quick Check:

Want More Practice?