Re: PQntuples return type - Mailing list pgsql-general

From Tom Lane
Subject Re: PQntuples return type
Date
Msg-id 20138.1190814645@sss.pgh.pa.us
Whole thread Raw
In response to Re: PQntuples return type  (Bruce Momjian <bruce@momjian.us>)
Responses Re: PQntuples return type  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Bruce Momjian <bruce@momjian.us> writes:
> Greg Sabino Mullane wrote:
>> There may be some other safeguards in place I did not see to prevent this,
>> but I don't see a reason why we shouldn't use unsigned int or
>> unsigned long int here, both for ntups and the return value of the
>> function.

> On second thought, I have at least updated the function documentation:

>        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.

This is silly.  Have you forgotten that the max number of columns is
constrained to 1600 on the backend side?

            regards, tom lane

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: Re: subquery/alias question
Next
From: "Scott Marlowe"
Date:
Subject: Re: Filesystem crash - corupted database