Received: from lscorp.com (poohbah.lscorp.com [207.152.64.2]) by hub.org (8.8.8/8.7.5) with ESMTP id PAA00547 for ; Fri, 3 Jul 1998 15:13:03 -0400 (EDT) Received: from [207.152.64.133] by lscorp.com with SMTP (Eudora Internet Mail Server 1.2); Fri, 3 Jul 1998 14:11:05 -0500 X-Sender: lynch@poohbah.lscorp.com Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: pgsql-sql@postgreSQL.org From: lynch@lscorp.com (Richard Lynch) Subject: Re: [SQL] Typecasting within sql statement. Date: Fri, 3 Jul 1998 14:11:05 -0500 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