Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA48315 for ; Wed, 19 Jan 2000 13:11:49 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id NAA10441; Wed, 19 Jan 2000 13:11:21 -0500 (EST) To: Marc Tardif cc: Jose Soares , pgsql-sql@postgreSQL.org Subject: Re: [SQL] char(19) to varchar(32) In-reply-to: <10207.948302673@sss.pgh.pa.us> References: <10207.948302673@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Wed, 19 Jan 2000 12:24:33 -0500" Date: Wed, 19 Jan 2000 13:11:20 -0500 Message-ID: <10438.948305480@sss.pgh.pa.us> From: Tom Lane I wrote: > create table prod_base (company char(19)); > create table company_base (company varchar(32)); > update prod_base set company = company_base.company; > ERROR: Type of 'company' does not match target column 'company' > This sure looks like a bug to me... I recommend a CAST as a workaround > for now, but I'll try to fix it for 7.0. Actually, it seems it's fixed in current sources already. regards, tom lane