Обсуждение: Problem in Function returning Cursors - Postgres Sql 7.2

In PostgreSql 7.2,
  i have written one stored procedure using CURSORS.


 CREATE FUNCTION reffunc3(refcursor) RETURNS refcursor AS '
 BEGIN
         OPEN $1 FOR SELECT empName  FROM tbl_employee;
         RETURN $1;
 END;
   '  LANGUAGE 'plpgsql';
 BEGIN;
 SELECT reffunc('funccursor');
 FETCH ALL IN funccursor;
 COMMIT;

   ** Function is created successfully
   ** While executing the SELECT of function,it is returning the
Cursor
 ** While     using the FETCH ALL IN  Command ,it is simply saying
"Query Execuetd OK!"

   How can i get the Result sets ?

Sudharsan