wat is the max number of rows that can be returned - Mailing list pgsql-novice

From HK
Subject wat is the max number of rows that can be returned
Date
Msg-id Pine.LNX.4.33.0212041626160.21525-100000@daisy.midascomm.com
Whole thread Raw
Responses Re: wat is the max number of rows that can be returned
List pgsql-novice
hi all,
i am using postgreSQL7.1.3 with libPQ C API.

suppose i create a table tbl (col int8 primary key) and populate the table
to the full.
Now if i retreive the result with

int a;
..
result = pqexec(conn, "select * from tbl");
a = PQntuples (result);
..

what will be the value of a.

The value must surely wrap around, i presume (PQntuples returns int).
Is this limitation because of C API??

When there is provision to insert that many rows, is there any ways to
obtain the correct number of rows. (thru' C API). Or is it possible in
any other API.

tia.
--
regards,
hari


pgsql-novice by date:

Previous
From: "Erwan DUROSELLE"
Date:
Subject: Rép. : Very slow performance
Next
From: Joel Burton
Date:
Subject: Re: wat is the max number of rows that can be returned