Re: [SQL] char(19) to varchar(32)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Tardif <admin(at)wtbwts(dot)com>
Cc: Jose Soares <jose(at)sferacarta(dot)com>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] char(19) to varchar(32)
Date: 2000-01-19 18:11:20
Message-ID: 10438.948305480@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Spratlen 2000-01-19 19:16:30 Foreign Keys, Triggers and such
Previous Message Tom Lane 2000-01-19 18:07:26 Re: [SQL] index usage ... strange !?