Use DEMO_DB; CREATE FUNCTION t() RETURNS TABLE(msg VARCHAR) AS $$ SELECT ‘Hello’ UNION SELECT ‘World’ $$; SELECT * FROM TABLE(t());