Re: Getting Recordset through returning refcursor
Clemens Ladisch <[email protected]> Fri, 15 Nov 2019 14:29:18 +0100
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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