Bret Stern wrote:
>
> trying to update a varchar numeric string column
> by converting it to int, adding a numeric value and insert it back
> as a varchar
>
> Having trouble with cast
I assume you are doing an update as opposed to an insert. You use
both above (and both numeric and int as well). Anyway, try:
update tbl set col = (col::int + 1);
or some variation thereof. That should do the trick.
Bosco.