Re: PQntuples return type

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> This is silly. Have you forgotten that the max number of columns is
> >> constrained to 1600 on the backend side?
>
> > Uh, this is the number of returned rows, right? How does this relate to
> > columns?
>
> Duh, brain fade on my part, sorry. Still, I suspect the return type of
> PQntuples would be the very least of the changes we'd need to make to
> support resultsets > 2G rows. And I would not advise changing it to an
> unsigned type, since that could cause hard-to-find breakage in
> comparison logic in applications.

Uh, yea. Not sure if anyone has ever tried. At least we have a marker
in the docs now that it might be a problem. ;-)

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +