Hi Gurus, I have a table with datatype as bitstrings create table test_a (b bit(3)); insert into test_a values ('111'); This will convert a bit to a number ========================== select to_number((substring(b,1,1)::int),9)+3 from test_a; How will I convert a Number to a bit ---------------------------------- insert into test_a values (to_char(1,'9')); ERROR: column "b" is of type bit but expression is of type textHINT: You will need to rewrite or cast the expression. Please help me regards skarthi
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных