-----Original Message-----
Oops, there was a typo in my second example. Still have the problemtho...
> rs=#> rs=# insert into table2> rs=# select CAST(my_Id as integer)> ^^^^> rs=# from table1;> ERROR: Cannot cast type character to integer>