Try something like this:
update myTable set field = 42::text::varchar;
I think the int4 --> text converter is written, and text --> varchar is
written, but int4 --> varchar is not.
Basically, anytime you need to go from one type to another that doesn't
seem to have a converter, look for a more general intermediate type.
At least, that's my understanding after one fight with this. :-)
--
--
-- "TANSTAAFL" Rich lynch(at)lscorp(dot)com