Re: stored procedure returning result set. - Mailing list pgsql-jdbc

On Tue, 23 Sep 2008, Gohil, Hemant wrote:

> Thank you very much for links. I was able to create the function fine.
> If it is not for asking too much - how would I display actual results
> from the cursor using SQL clients like Aqua Data Studio or SQuirreL SQL
> Client ?

I'm not familiar with either of those clients, but here's how you would do
it in psql using the function definition from example 6.3 of the
documentation I pointed you to.

jurka=# begin;
BEGIN
jurka=# select refcursorfunc();
    refcursorfunc
--------------------
  <unnamed portal 1>
(1 row)

jurka=# fetch all from "<unnamed portal 1>";
  ?column?
----------
         1
         2
(2 rows)

Kris Jurka