[BUGS] BUG #1578: ::bit(n) behaves "differently" if applied to bit strings than integers. -
04-10-2005
, 02:23 PM
The following bug has been logged online:
Bug reference: 1578
Logged by: Celia McInnis
Email address: celia (AT) drmath (DOT) ca
PostgreSQL version: 8.0.1
Operating system: Linux
Description: ::bit(n) behaves "differently" if applied to bit strings
than integers.
Details:
It's probably not good (at least for mathematicians!) to have the following
give different results:
select B'1110110101'::bit(6);
select B'1110110101'::integer::bit(6);
The first gives 110101 (the 6 least significant bits).
The second gives 111011 (the 6 most significant bis).
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org) |