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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
