Rick Seeger writes:
> 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().
--
Peter Eisentraut peter_e(at)gmx(dot)net