[SQL] Type conversion

[Ice Planet]

Hello

I have following situation

create table t1 (a int8 primary key, b int8);
create table t2 (x int2);
insert into t1 values (1,1);

A: insert into t2 values (select b from t1 where a = 1)

B: insert into t2 values (select int2(int4(b)) from t1 where a = 1)

Both possibilites fail, how can i do this insert???

Thanks for help

                       Best regards
                                              Ice Planet

e-mail: [EMAIL PROTECTED]
ICQ#: 67765483