Re: Calculated update - Mailing list pgsql-general

From Bret Stern
Subject Re: Calculated update
Date
Msg-id 1331601094.2167.32.camel@fedora13
Whole thread Raw
In response to Re: Calculated update  (Bosco Rama <postgres@boscorama.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Bosco Rama
Date:
Subject: Re: Calculated update
Next
From: John R Pierce
Date:
Subject: Re: Upgrade questions