| From: | Melvin Call <melvincall979(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to determine max int |
| Date: | 2013-11-12 00:36:38 |
| Message-ID: | CADGQN546wD5LQCEjO6sWF7iiJZgvk8CxP7H=F2wbNr1_LqhiRg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Nov 11, 2013 at 6:29 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> 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.
>
That is what I thought. I have no idea where I came up with the notion that
it was 64 bits, but I have it in a note I took a while back. I guess I
really am going crazy!
Thanks John
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Call | 2013-11-12 00:38:48 | Re: How to determine max int |
| Previous Message | Guy Rouillier | 2013-11-12 00:35:14 | Re: How to determine max int |