Re: refcursor returned by pl/psql to jdbc

Dave Cramer wrote:
> Richard,
>
> The problem is that the cursor is un-named. Is there a way to name the
> cursor? jdbc doesn't know what to do with a column named <unnamed cursor
> 1>

Yes, you can name the cursor.  See my new doc section at the bottom of:

    http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html

You have to pass the cursor name into the function.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026