Re: [Ruby-DBI-devel] Is rows reliable for SELECT statements?

[Michael N. <uu...@rz...>]

Paul DuBois wrote:
> Use of $sth->rows in Perl DBI is discouraged for obtaining a row count
> from SELECT statements, do to the fact that not all drivers return the
> row count reliably until all the rows have been fetched (if at all).
> Instead, the docs recommend counting the rows as you fetch them.
> 
> Does the same apply to Ruby DBI?

Statement#rows does not return the number of rows in the result set!
Instead it returns the RPC (Row Processed Count) which is only valid
for DELETE/UPDATE.

But depending on the DBD it may also work with SELECT statements.

Regards,

  Michael