how to use postgresql function in another function which returns set of Refcursor

Question

My Function as Follows

CREATE OR REPLACE FUNCTION get_history(refcursor, encounterid integer, patientid integer) RETURNS SETOF refcursor

Begin

end

How to use above function in another function.

Erwin Brandstetter · Accepted Answer · 2013-01-22 11:36:26Z

2

Why would you want to return SETOF refcursor?

Maybe you want

 RETURNS TABLE( ...)

or

 RETURNS SETOF some_composite_type

You call that like any other SELECT command ..

SELECT * FROM get_history(...)

And can use it in a plpgsql LOOP:

FOR my_row_var IN
    SELECT * FROM get_history(...)
LOOP
  -- do stuff
END LOOP;

Or just

 RETURNS refcursor

Even including an example for RETURNS SETOF refcursor.

answered Jan 22, 2013 at 11:30

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1