Re: Calculated update

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.