Re: BUG #8191: Wrong bit conversion

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8191: Wrong bit conversion
Date: 2013-06-01 04:26:10
Message-ID: 51A977E2.6030101@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 5/31/2013 6:01 PM, Gavin Flower wrote:
>> SQL's BIT type is big endian, a hangover from its IBM mainframe
>> heritage.
>>
>>
>>
>>
>>
> I don't think it has anything to do with byte sex (I know of 3 ways to
> store integers in memory, and I suspect there are more !).

I was thinking of bit sex, not byte.

IBM numbers bits such that bit 0 is the most significant bit of a word.

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-06-01 04:27:38 Re: BUG #8191: Wrong bit conversion
Previous Message Gavin Flower 2013-06-01 02:38:45 Re: BUG #8191: Wrong bit conversion