Forum OpenACS Q&A: Response to alter column type problem.

Collapse
9: Response to alter column type problem. (response to 1)
Posted by Dan Wickstrom on 06/20/01 08:34 PM
postgresql is not smart with regards to casting. You need to provide the full coercion path. 

insert ...
select ... mark_1::float8::varchar ...