Given a function definition something like this:
CREATE FUNCTION getrefcursor (rc OUT refcursor)
FOR SELECT * FROM <some_table>
$$ LANGUAGE plpgsql;
How should this function be called from a console? And how should the call be set up so that we can see the result set produced by the function?