Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: fetchsize dynamically changeable?


  • From: Oliver Jowett <oliver(at)opencloud(dot)com>
  • To: Guido Fiala <guido(dot)fiala(at)dka-gmbh(dot)de>
  • Cc: pgsql-jdbc(at)postgresql(dot)org
  • Subject: Re: fetchsize dynamically changeable?
  • Date: Wed, 28 Jul 2004 20:08:38 +1200
  • Message-id: <41075F06.9080508@opencloud.com> <text/plain>

Guido Fiala wrote:
Given all the other requirements for cursors are met, is it possible to change the fetchsize on the fly?

e.g.
conn.createStatement(...);
st.setFetchsize(1);
rs=st.executeQuery(...);//we got the first record
st.setFetchsize(10);
rs.next(); //now we got records nr. 2-11 in memory and sit at nr. 2

That should work.

-O



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group