Re: PQntuples return type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PQntuples return type
Дата
Msg-id 20138.1190814645@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PQntuples return type  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: PQntuples return type  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Madison Kelly
Дата:
Сообщение: Re: subquery/alias question
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Filesystem crash - corupted database