SQL Syntax: char to varchar type conversion(s)

Hello,

Can anyone answer this SQL question?

I have a field of type char in one table and wish to insert this
into a second table (with other fields) but the new field is of
type varchar. How do I proceed? The following (test) fails in pgsql.

create table temp1 ( code char(2) );
insert into temp1 values ('AB');
select * from temp1;
create table temp2 ( code1 char(10), code2 varchar(10) );
insert into temp2 (code1,code2) select code,code from temp1;
select * from temp2;

Rachel Street

****************************************************************
* R K Street - RAL Database Systems - (01235) 821900 ext 5833 *
* Rutherford Appleton Laboratory, Chilton, DIDCOT, Oxon, UK *
* Email: R(dot)K(dot)Street(at)rl(dot)ac(dot)uk or street(at)wdcc1(dot)bnsc(dot)rl(dot)ac(dot)uk *
****************************************************************