Shouldn't I expect all results to be 000...0001?
Otherwise it would be
1 !=3D 1?
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Friday, May 31, 2013 5:34 PM
To: Gerald Luger
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #8191: Wrong bit conversion
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
