Thread: [GENERAL] Retrieving query results
Hi, ALL, [quote] PQntuples Returns the number of rows (tuples) in the query result. Because it returns an integer result, large result sets might overflow the return value on 32-bit operating systems. int PQntuples(const PGresult *res); [/quote] Is there another way to not to overflow the result? Thank you.
On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot <ikorot01@gmail.com> wrote: > [quote] > PQntuples > > Returns the number of rows (tuples) in the query result. Because it > returns an integer result, large result sets might overflow the return > value on 32-bit operating systems. > > int PQntuples(const PGresult *res); > [/quote] > > Is there another way to not to overflow the result? Not really with the existing API. Note that getting at 2 billion rows is really a lot, and would cause performance issues on the application side because a bunch of data would need to be processed, and getting out this much data is not network-wise anyway. -- Michael
Hi, Michael, On Tue, Aug 22, 2017 at 8:32 PM, Michael Paquier <michael.paquier@gmail.com> wrote: > On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot <ikorot01@gmail.com> wrote: >> [quote] >> PQntuples >> >> Returns the number of rows (tuples) in the query result. Because it >> returns an integer result, large result sets might overflow the return >> value on 32-bit operating systems. >> >> int PQntuples(const PGresult *res); >> [/quote] >> >> Is there another way to not to overflow the result? > > Not really with the existing API. What do you mean "not really" > Note that getting at 2 billion rows > is really a lot, and would cause performance issues on the application > side because a bunch of data would need to be processed, and getting > out this much data is not network-wise anyway. That's OK, As long as my program works with arbitrary number of rows. Thank you. > -- > Michael