Ice Planet <ice@adiemus.sk> writes:
> B: insert into t2 values (select int2(int4(b)) from t1 where a = 1)
Works for me when spelled correctly:
regression=# insert into t2 (select int2(int4(b)) from t1 where a = 1);
INSERT 314647 1
If you make a suitable conversion function then you can omit the
explicit conversion:
regression=# create function int2(int8) returns int2 as
regression-# 'begin return int2(int4($1)); end;' language 'plpgsql';
CREATE
regression=# insert into t2 (select b from t1 where a = 1);
INSERT 314649 1
regards, tom lane