Re: Cursor returned from procedure ignores setFetchSize() on

From: Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)uk>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: "Brian G(dot) Huber" <brianghuber(at)yahoo(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cursor returned from procedure ignores setFetchSize() on
Date: 2004-06-08 20:12:55
Message-ID: 878yex7qrc.fsf@tapsellferrier.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris Jurka <books(at)ejurka(dot)com> writes:

> I was under the impression that refcursor returning functions would fade
> with the advent of easier set returning functions. Have you considered
> using them instead? The advantage of returning refcursor seems to me that
> you don't need to create a pseudo type for the return value, or deal with
> specifying record types in the query. Are there other advantages I'm
> missing?

Portability. Efficiency.

Nic

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alvaro Herrera 2004-06-08 22:23:56 Nested transactions
Previous Message Kris Jurka 2004-06-08 15:56:05 Re: Cursor returned from procedure ignores setFetchSize() on