Re: PQntuples return type - Mailing list pgsql-general

From Bruce Momjian
Subject Re: PQntuples return type
Date
Msg-id 200709262131.l8QLVer15979@momjian.us
Whole thread Raw
In response to Re: PQntuples return type  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PQntuples return type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> 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?

Uh, this is the number of returned rows, right?  How does this relate to
columns?

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

pgsql-general by date:

Previous
From: Diego Gil
Date:
Subject: datestyle question
Next
From: Erik Jones
Date:
Subject: Re: datestyle question