Function to return both integer and SETOF refcursor - Mailing list pgsql-general

From Chuck Bai
Subject Function to return both integer and SETOF refcursor
Date
Msg-id 482E47EC.5010305@gmail.com
Whole thread Raw
In response to escaping and quoting  (Maarten Deprez <maarten.deprez@scarlet.be>)
Responses Re: Function to return both integer and SETOF refcursor  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I got the following error when try to create a function to return an
integer and SETOF refcursor. I want to get refcursors back along with an
Out parameter in one function. There seems to be a conflict on return
type. How do I fix it? Thanks.

ERROR:  function result type must be integer because of OUT parameters

CREATE OR REPLACE FUNCTION testrefcursor(IN uid integer, OUT tcount integer)
  RETURNS SETOF  refcursor AS
$BODY$
DECLARE
  o_user refcursor;
  o_name refcursor;
BEGIN
    tcount := 100; -- add some logic to calculate tcount
    OPEN o_user FOR SELECT * FROM usr_table where usr_id = uid;
    RETURN NEXT o_user;
    OPEN o_name FOR SELECT * FROM temp_table;
    RETURN NEXT o_name;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL executing my function too many times during query
Next
From: Tom Lane
Date:
Subject: Re: Using role priviledges for pg_dump