Problem in Function returning Cursors - Postgres Sql 7.2 - Mailing list pgsql-general

From ramkumarm@npd.hcltech.com (Ramkumar)
Subject Problem in Function returning Cursors - Postgres Sql 7.2
Date
Msg-id dc73a585.0309172042.603318a7@posting.google.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: varchar vs. text
Next
From: david_shadovitz@xontech.com (David Shadovitz)
Date:
Subject: Re: Where are PL/pgSQL functions stored?