On Mon, Nov 11, 2013 at 6:29 PM, John R Pierce <pie...@hogranch.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