Hi, Michael, On Tue, Aug 22, 2017 at 8:32 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote: > On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot <ikorot01@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
