Re: How to determine max int

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to determine max int
Date: 2013-11-12 00:29:11
Message-ID: 52817657.9090401@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2013-11-12 00:35:14 Re: How to determine max int
Previous Message Jeffrey Walton 2013-11-12 00:20:15 Postgres 9.3.1 and Self Test Failure "pg_regress: no *.source files found"