Re: BUG #8191: Wrong bit conversion - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #8191: Wrong bit conversion
Date
Msg-id 51A977E2.6030101@hogranch.com
Whole thread Raw
In response to Re: BUG #8191: Wrong bit conversion  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List 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

pgsql-bugs by date:

Previous
From: Gavin Flower
Date:
Subject: Re: BUG #8191: Wrong bit conversion
Next
From: Tom Lane
Date:
Subject: Re: BUG #8191: Wrong bit conversion