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

Поиск
Список
Период
Сортировка
От Valerio Santinelli
Тема Another one! :) How to convert char(1) to boolean without re-exporting tables.
Дата
Msg-id 36A49D88.E92C2B48@mediacom.it
обсуждение исходный текст
Ответы Re: [GENERAL] Another one! :) How to convert char(1) to boolean without re-exporting tables.  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Randy Dees
Дата:
Сообщение: Access database from PostgreSQL?
Следующее
От: Herouth Maoz
Дата:
Сообщение: Re: [GENERAL] Another one! :) How to convert char(1) to boolean without re-exporting tables.