Hi skarthi,
On Wed, 2007-04-11 at 13:30 -0700, Karthikeyan Sundaram wrote:
> insert into test_a values (to_char(1,'9'));
>
> ERROR: column "b" is of type bit but expression is of type
> text
> HINT: You will need to rewrite or cast the expression.
As suggested by the error, you should use a cast, e.g.,
insert into test_a values 9::bit(3);
This will result in binary '001' being inserted because you need 4 bits
to represent decimal 9.
Joe
