>
>> Oops, there was a typo in my second example. Still have the problem
>> tho...
>>
>> > rs=#
>> > rs=# insert into table2
>> > rs=# select CAST(my_Id as integer)
>> > ^^^^
>> > rs=# from table1;
>> > ERROR: Cannot cast type character to integer
>
> Try the function to_number().
>
rs=# select to_number(my_Id,'9999999999999999') from table1;
It worked nicely. Thanks.
--Rick