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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
