Re: BUG #4947: libpq PQntuples should return 64-bit number

On Tue, Jul 28, 2009 at 08:54, Jim Michaels<jmichae3(at)yahoo(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4947
> Logged by:          Jim Michaels
> Email address:      jmichae3(at)yahoo(dot)com
> PostgreSQL version: 8.4.0
> Operating system:   Win XP Pro Sp3
> Description:        libpq PQntuples should return 64-bit number

Why?

Do you have an actual use-case where PQexec() would return more than 2
billion rows, and not have other much more complex issues? For
example, the fact that they all have to be materialized in memory?

Also, this would break compatibility with previous versions, so I
think it would have to be a new function name, like PQntuples64(). But
we'd have to see an actual use-case first...

> I agree that 64-bit numbers are compiler-specific.  this can be overcome
> with something like the following code:
>
> although now I understand that the microsoft 2008 compiler implements
> UINT128, UINT8, UINT64, UINT32, INT64 and the like, but the MINGW compiler
> and BCC++5.5 do not necessarily implement them.
>
> maybe with some #if defined(INT64) the following code could be made proper.
> something common to all 32-bit microsoft compilers is the __int64 type.

You seem to be focused on the Windows platform there. There are a
whole lot more platforms needed. But we already have generic types for
64-bit available in our headers, in the form of int64 and uint64.

--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/