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 *
****************************************************************
