Re: [SQL] char(19) to varchar(32) - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] char(19) to varchar(32)
Date
Msg-id 10438.948305480@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] char(19) to varchar(32)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] index usage ... strange !?
Next
From: Daniel Spratlen
Date:
Subject: Foreign Keys, Triggers and such