Calculated update

On 03/12/2012 06:28 PM, 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

Possibly having trouble with two casts: one from string to int, one
from int to string? You sql would help.

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.

On Mon, 2012-03-12 at 17:39 -0700, Bosco Rama wrote:

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.

update open_orderheader
set order_id = (order_id::int + 3000)
where module_id='aggregate'

worked as advertised.
thanks for the help guys.