Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting Recordset through returning refcursor - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: Getting Recordset through returning refcursor
Date
Msg-id d857345e-d107-28bf-0382-33bf53807e2a@ladisch.de
Whole thread Raw
In response to Getting Recordset through returning refcursor  ("Kubilay Kaan" <heraklea@gmx.de>)
List pgsql-odbc
Tree view 
Kubilay Kaan wrote:
> So my question is does the ODBC driver supports refcursor??

The ODBC driver just transmits all SQL commands to the database.

As far as I know, the refcursor type is not available in SQL, only in PL/pgSQL,
which can be used only inside functions.

> "select GetRecordSetByID_ref('refcur', 1); FETCH ALL IN \"refcur\";"

Do these commands work when executed in psql?


Regards,
Clemens

pgsql-odbc by date:

Previous
From: "Kubilay Kaan"
Date:
Subject: Getting Recordset through returning refcursor
Next
From: Carol Hutton
Date:
Subject: RE: Saba Updated Users List - Talent Management Software