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

Collapse
Posted by Dan Wickstrom on
postgresql is not smart with regards to casting. You need to provide the full coercion path.

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