Re: PQntuples return type

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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