Shouldn't I expect all results to be 000...0001? Otherwise it would be 1 != 1?
-----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Friday, May 31, 2013 5:34 PM To: Gerald Luger Cc: [email protected] Subject: Re: [BUGS] BUG #8191: Wrong bit conversion [email protected] 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 -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
