Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #8191: Wrong bit conversion
Date
Msg-id 11097.1370036031@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8191: Wrong bit conversion  (gerald@hexboss.com)
Responses Re: BUG #8191: Wrong bit conversion  (Gerald Luger <GeraldLuger@hexboss.com>)
List pgsql-bugs
Tree view 
gerald@hexboss.com writes:
> SELECT b'1'::bit(64), x'1'::bit(64), 1::bit(64)

> RESULT:
> "1000000000000000000000000000000000000000000000000000000000000000",
> "0001000000000000000000000000000000000000000000000000000000000000",
> "0000000000000000000000000000000000000000000000000000000000000001"

I believe those are all operating as intended.

            regards, tom lane

pgsql-bugs by date:

Previous
From: aray1985@yahoo.com
Date:
Subject: BUG #8196: problem with left join and is null check
Next
From: Gerald Luger
Date:
Subject: Re: BUG #8191: Wrong bit conversion