Joost Kraaijeveld wrote:
> > ALTER TABLE ... ALTER COLUMN TYPE might help you. Use the USING clause
> > if you need a non-default data conversion -- in this case it might look
> > like USING (col = '1') or some such.
>
> ALTER TABLE odbcdest ALTER COLUMN odbc_bool TYPE bool
>
> gives:
>
> ERROR: column "odbc_bool" cannot be cast to type "bool"
You need a USING clause, as Tom suggests above (even giving an example).
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.