Dave Cramer <davecramer@gmail.com> writes: > Obviously I am biased by the JDBC API which would like to have > PreparedStatement.execute() return the number of rows inserted > without having to wait to read all of the rows returned
Umm ... you do realize that we return the rows on-the-fly?
I do realize that.
The server does not know how many rows got inserted/returned
Well I haven't looked at the code, but it seems unintuitive that adding the returning clause changes the semantics of insert.
until it's run the query to completion, at which point all the data has already been sent to the client. There isn't any way to return the rowcount before the data, and it wouldn't be some trivial protocol adjustment to make that work differently. (What it *would* be is expensive, because we'd have to store those rows somewhere.)
I wasn't asking for that, I just want the number of rows inserted.
