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

You have to cast the varchar field as char. Example: CAST (company AS CHAR)

For example:

CREATE TABLE test (
company varchar(32)
);
insert into test values('12345678901234567890123456789012');

CREATE TABLE test1 (
company char(19)
);
insert into test1 (company) select cast(test.company as char);

select * from test;
company
--------------------------------
12345678901234567890123456789012
(1 row)

select * from test1;
company
-------------------
1234567890123456789
(1 row)

José

Marc Tardif wrote:

> I have created a rule to update a char(19) field from a varchar(32) field.
> I don't mind if half the field is cut out, I just want to copy the first
> 19 characters. Here's what I have
> ... update products set company=NEW.company;
>
> company is char(19);
> NEW.company is varchar(32);
>
> Any suggestions on making this work?
> Marc
>
> ************