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