I would like to return a set of records from a pl/pgsql. Is there a way to do that without using the "for" construct and cursors? For instance when I compared these two stored procedures:
create or replace function sqlProc () returns setof integer as $$ select * from foo; $$ language sql; create or replace function plpgSqlProc () returns setof integer as $$ declare c integer; begin for c in select * from foo loop return next c; end loop; end; $$ language plpgsql;
The pure SQL version has 2x better time performance than the pl/pgsql one! Unfortunately I have other logic that cannot be expressed in pure SQL so I am wondering how I should write my stored procedure?