Samuel Williams <space.ship.traveller@xxxxxxxxx> writes: > Those methods don't seem to have an equivalent in libpq - you can use > PQgetResult but it buffers all the rows. Using single row mode results > in many results for each query (seems like a big overhead). Have you got any actual evidence for that? Sure, the overhead is more than zero, but does it mean anything in comparison to the other costs of data transmission? > Maybe the statement about efficiency is incorrect, but it would be > nice if you could incrementally stream a single result set more > easily. More easily than what? If we did not construct a PGresult then we would need some other abstraction for access to the returned row, dealing with error cases, etc etc. That would mean a lot of very duplicative API code in libpq, and a painful bunch of adjustments in client code. regards, tom lane