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

From John R Pierce
Subject Re: BUG #8191: Wrong bit conversion
Date
Msg-id 51A9406B.9040908@hogranch.com
Whole thread Raw
In response to Re: BUG #8191: Wrong bit conversion  (Gerald Luger <GeraldLuger@hexboss.com>)
Responses Re: BUG #8191: Wrong bit conversion
List pgsql-bugs
On 5/31/2013 4:29 PM, Gerald Luger wrote:
> Shouldn't I expect all results to be 000...0001?
>
> Otherwise it would be
> 1 != 1?

SQL's BIT type is big endian, a hangover from its IBM mainframe heritage.





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

pgsql-bugs by date:

Previous
From: healthycomputers@persona.ca
Date:
Subject: BUG #8197: Error Message When trying to install PS8.1
Next
From: Gavin Flower
Date:
Subject: Re: BUG #8191: Wrong bit conversion