Re: [SQL] alter column type from boolean to char with default doesn't work

"Markus Bertheau" <[EMAIL PROTECTED]> writes: > I basically want to change a boolean column to char. The boolean > column has a default of true. The char column should have 'f' for > false and 't' for true. I think that an SQL statement like the > following should work, but it doesn't: Hmm ... the

[SQL] alter column type from boolean to char with default doesn't work

Hi, I basically want to change a boolean column to char. The boolean column has a default of true. The char column should have 'f' for false and 't' for true. I think that an SQL statement like the following should work, but it doesn't: blog=> select version();