[GENERAL] Calculated update

2012-03-12 Thread Bret Stern
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Calculated update

2012-03-12 Thread Rob Sargent
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

Re: [GENERAL] Calculated update

2012-03-12 Thread Bosco Rama
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).

Re: [GENERAL] Calculated update

2012-03-12 Thread Bret Stern
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