Re: How to determine max int

On 11/11/2013 4:14 PM, Melvin Call wrote:
> I could swear I read somewhere that the default integer size on 64-bit
> systems running 9.1 is eight bytes, or the equivalent of a bigint. But
> reading through the user guide it seems that it is indeed still just
> four-bytes. Can anyone verify that for me, or point me to a way to
> verify it? I see nothing in pg_settings which is where I thought to
> look. Not a big deal, I just need to know for the data dictionary.

x86_64 integers are 32bit, bigints are 64bit.    this is true in most
all programming environments, from C on.





--
john r pierce                                      37N 122W
somewhere on the middle of the left coast