Thread: How do I return a cursor thought the ODBC driver

I have created a function in postgres called getallusers(var) that returns a cursor. This works fine at the psql level but when I try to return it through ODBC I get a variety of errors.

 

The function is as follows:

 

CREATE OR REPLACE FUNCTION getallusers(refcursor) RETURN refcursor AS'

 

begin

open $1 for select * from users;

return $1;

end;

' language 'plpgsql';

 

 

I call it like this at the psql level:

 

begin

select getallusers('rs');

fetch all in rs;

commit;

 

This works fine in psql as I mentioned but not when I try to query it through ODBC.