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: ice(at)adiemus(dot)sk
ICQ#: 67765483