Another one! :) How to convert char(1) to boolean without re-exporting tables. - Mailing list pgsql-general

Ok. This time it's a bit more difficult ;)

I'd like to convert my char(1) stuff to boolean without having to kill
the table and re-export the original from MSAccess. I think there's a
way to do that since just creating a new table with bool instead of
char(1) won't let me insert into it the values contained in the old
table seeing they're not of the same type.

Thanks as always!! :)

Valerio Santinelli
tanis@mediacom.it