wat is the max number of rows that can be returned

From: HK <harikrishnan(at)midascomm(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: wat is the max number of rows that can be returned
Date: 2002-12-04 11:07:07
Message-ID: Pine.LNX.4.33.0212041626160.21525-100000@daisy.midascomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2002-12-04 15:28:32 Re: wat is the max number of rows that can be returned
Previous Message Erwan DUROSELLE 2002-12-04 07:29:57 Rp. : Very slow performance