Re: Getting Recordset through returning refcursor

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: Getting Recordset through returning refcursor
Date: 2019-11-15 13:29:18
Message-ID: d857345e-d107-28bf-0382-33bf53807e2a@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Carol Hutton 2019-11-19 13:07:57 RE: Saba Updated Users List - Talent Management Software
Previous Message Kubilay Kaan 2019-11-15 12:05:00 Getting Recordset through returning refcursor