Learning PostgreSQL 11 - Third Edition

Returning multiple rows

Set returning functions (SRFs) can be used to return a set of rows. The row type can either be a base type, such as an integer, composite, table type, pseudo type, or domain type. To return a set from a function, the SETOF keyword is used to mark the function as an SRF, as follows:

-- In SQL CREATE OR REPLACE FUNCTION car_portal_app.car_model(model_name TEXT) RETURNS SETOF car_portal_app.car_model AS $$  SELECT car_model_id, make, model FROM car_portal_app.car_model WHERE model = model_name;$$ LANGUAGE SQL;-- In plpgSQLCREATE OR REPLACE FUNCTION car_portal_app.car_model1(model_name TEXT) RETURNS SETOF car_portal_app.car_model AS $$BEGIN RETURN QUERY SELECT car_model_id, make, model FROM car_portal_app.car_model WHERE ...