On Fri, 29 Apr 2005, Antony Paul wrote:
> I am using PostgreSQL 7.3 (server and JDBC driver) and no stored
> procedures are used but uses the built in functions. I know that in
> this version PreparedStatements are not kept in the server. What about
> the ResultSet ?. Does all the data is transferred to application right
> after the query is executed or only a predefined no of records are
> returned while going through the rs.next() call ?.
>
In 7.3 all ResultSets fetch the entire result immediately leaving
nothing on the server.
Kris Jurka