RE : Nmber of rows in a ResultSet

> On Fri, 9 Jan 2004, Kris Jurka wrote:
>
> > In the last JDBC drivers, is there a means to get the number of rows
> > directly (without using 'SELECT COUNT(*)' or
> 'rs.last();rs.getrow();') ?
>
> I don't see what's so wrong with rs.last() and rs.getRow().
>

Thank you for the response.

What is wrong with rs.last() and rs.getRow() is
- it requires scrollable cursors in order to get back to the first row
- it will certainly slow down the operation in case of huge amount of
rows (I don't known how the Postgres driver handle that, so maybe this
is wrong... I hope so)



Regards
--
Xavier Bugaud
www.gloptv.com