confused about bit strings
От | Neil Conway |
---|---|
Тема | confused about bit strings |
Дата | |
Msg-id | 1065634733.3423.21.camel@tokyo обсуждение исходный текст |
Ответы |
Re: confused about bit strings
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: