Re: Returning back a resultset from a stored function

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Daniel Daoust <daoustd_ca(at)yahoo(dot)ca>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Returning back a resultset from a stored function
Date: 2004-08-27 16:06:07
Message-ID: 200408271806.07016.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Daniel Daoust wrote:
> I have found that "psqlodbc" does not support the
> refcursor type.
> I also investigated the following form: " select *
> from somefunc(); ", but realized that this worked only
> inside "PL/pgSQL", therefore could not be used
> directly from SQL.

"select * from somefunc();" is certainly SQL, so what is the problem?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Eisentraut 2004-08-27 16:06:53 Re: Bug ?
Previous Message Daniel Daoust 2004-08-27 15:04:09 Returning back a resultset from a stored function