PL/pgsql return resultset/cursor?

Is it possible to return a result-set or cursor from a PL/pgsql
procedure, like

CREATE OR REPLACE FUNCTION foo()
RETURNS <WHAT_TYPE> AS '
BEGIN
RETURN SELECT * from FOO;
END;
' LANGUAGE 'plpgsql';

If you open a cursor in a procedure, it gets closed when the procedure
exits, right?

Richard