Cursor problem

[Vidya <sivaramanvidhya@xxxxxxxxx>]

Hello All,

How do I create a cursor in psql .

 

I have a function which opens a cursor .

SampleDB=# create function reffunc(refcursor) returns refcursor as $$
SampleDB$# begin
SampleDB$# open $1 for select col from test;
SampleDB$# return $1;
SampleDB$# end;
SampleDB$# $$ language sql;
ERROR:  syntax error at or near "open" at character 67
LINE 3: open $1 for select col from test;

 

I am not able to create a cursor , it errors out at 'open '

 

 

I tried a still more simple one

        ^
SampleDB=# create or replace function test(refcursor) returns refcursor as $$

SampleDB=#begin
SampleDB$# syscur refcursor;

SampleDB=#end;
SampleDB$# $$ language sql;
ERROR:  syntax error at or near "syscur" at character 68
LINE 2: syscur refcursor;

 

How do I create a cursor .

 

Any help asap ?

Thanks

Vidya

---

Do you Yahoo!?
 
Yahoo! Small Business - Try our new resources site!