Re: PQntuples returns an int. - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: PQntuples returns an int.
Date
Msg-id 40762c8c32343e6af74e7f23f27d5c16@biglumber.com
Whole thread Raw
In response to PQntuples returns an int.  (Guillaume Yziquel <guillaume.yziquel@citycable.ch>)
Responses Re: PQntuples returns an int.  (Guillaume Yziquel <guillaume.yziquel@citycable.ch>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> I'm asking this because I'm wondering whether you could have more tuples
> in the result of a query than could be indexed by the 'int' type. May
> this happen?

Yes, but it's a low concern as many other things would break before
you got to that point. See:

http://groups.google.com/group/pgsql.general/browse_thread/thread/462c454345221267/f61926526b539036
or:
http://5z8.info/super-nsfw_cyd


- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201003031555
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkuOz1cACgkQvJuQZxSWSsge+wCg0Wmo/YyEkymE7Y1FILtRoO3J
CDQAn36Gs8Si37YdeheaM6v2JiU+EPOz
=e+3U
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: Justin Graf
Date:
Subject: Re: Scratching my head why results are different between machines.
Next
From: Greg Smith
Date:
Subject: Re: Raid 10 settings for optimal postgres performance?