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.K.Street@rl.ac.uk  or  street@wdcc1.bnsc.rl.ac.uk   *
****************************************************************