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.
