Rows Affected 
Author Message
 Rows Affected

Hi All,

    I am new here and hope this is the right place to ask this question.

    I am connecting to postgress using a sockect connection.  Everything
works fine.  However, there is one thing that is missing that I cannot
seem to find.  I need to get the number of rows affected by the various
queries that are being executing.

So if I execute an delete, insert or update statement I need to know how
many rows it affected.

Now on the other side I would like to do the same for select
statements.  However, I realize that select statements don't actually
have a row count until the query has completed execution.  I do not know
if that matters for postgress or for the socket based connection.  In
oracle (if i remember correctly) oracle would tell me the number of rows
affected or the number of rows for the filled buffer that was passed
back,  If it was a filled buffer then it would continue to grow until
the query had completed execution.  Anyway whatever information you can
supply would be helpful.  However information on this one is not as
important as information on the DML statements.

Thanks ahead of time,

Chris Lopeman

Wed, 22 Jun 2005 00:45:16 GMT
 [ 1 post ] 

 Relevant Pages 

1. "rows affected" message

2. Stored Proc parameter not working - O rows affected :-(

3. OSQL - Rows affected

4. Rows affected messages

5. MSSQL JDBC driver executeUpdate() problem (returns wrong number of rows affected)

6. faster not to return rows affected?

7. Execute T--SQL and only get rows affected

8. Supress (n row(s) affected)

9. Number of rows affected

10. Supress the "0 rows affected" messages

11. "(1 row(s) affected)"

12. Merant JDBC driver not returning number of rows affected

Powered by phpBB® Forum Software