Tom Lane wrote: > Bruce Momjian <bruce@xxxxxxxxxx> 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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster