Why isn't fetch showing data from refcursor in Postgres?

Question

Any idea why this doesn't display data, and how to fix that?

create or replace function test_refcursor(a refcursor) 
returns setof refcursor as
$$
begin
    open a for select from accounts;
    return next a;
end;
$$ language plpgsql;
begin;

Then to try to select data:

mydb=> begin;
mydb=> select test_refcursor('a');
 test_refcursor
----------------
 a
(1 row)
mydb=> fetch all from a;
--
(58 rows)

Last part doesn't display anything. Does it just not support dynamically type cursors like this?

klin · Accepted Answer · 2015-06-21 02:09:16Z

1

Last part doesn't display anything as you don't want anything. Try:

...
open a for select * from accounts;
...

answered Jun 21, 2015 at 2:09

klin

123k15 gold badges241 silver badges263 bronze badges

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

1 Comment

Rob N Over a year ago

Oh dear... it's getting late. Thank you, but I'm going to try to delete the question, as it's all based on a typo.

Collectives™ on Stack Overflow

Why isn't fetch showing data from refcursor in Postgres?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related