Re: [SQL] Typecasting within sql statement.

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@lscorp.com