Is the following behavior intentional? If so, what's the reasoning
behind it?
nconway=# select 1::bit;bit
-----0
(1 row)
nconway=# select '1'::bit;bit
-----1
(1 row)
nconway=# select X'1'::bit;bit
-----0
(1 row)
nconway=# select 1::bit varying;
ERROR: cannot cast type integer to bit varying
nconway=# select 4::int2::bit;
ERROR: cannot cast type smallint to bit
nconway=# select 4::bit;bit
-----0
(1 row)
nconway=# select '4'::bit;
ERROR: "4" is not a valid binary digit
nconway=# select X'4'::bit varying;varbit
--------0100
(1 row)
-- why is that 4 bits, not 3?
nconway=# select '14'::int::bit;bit
-----0
(1 row)
nconway=# select bit('14'::int);
ERROR: syntax error at or near "'14'" at character 12
nconway=# select "bit"('14'::int); bit
----------------------------------00000000000000000000000000001110
(1 row)
-- shouldn't bit be equivalent to bit(1), which should be
right-truncated?
Cheers,
Neil
