I have a table with the following schema:
CREATE TABLE foo (bar VARCHAR(32));

Every bar value has a format like a float, e.g. "2.5". Now I want that value
multiplied by two and saved again as varchar. I was hoping to do smth like:

UPDATE foo SET bar = TO_VARCHAR( TO_FLOAT(bar) * 2); -- INCORRECT!!!!

How is that done?

I know that the bar attribute ought to have type FLOAT, but I have to work
with this legacy database. And anyway this table will rarely be updated.

Sincerely, Thomas

Responses

• Re: Converting between varchar and float when updating at 2011-04-28 09:40:40 from Dmitriy Igrishin
• Re: Converting between varchar and float when updating at 2011-04-28 09:41:56 from Szymon Guz
• Re: Converting between varchar and float when updating at 2011-04-28 09:49:57 from Vibhor Kumar
• Re: Converting between varchar and float when updating at 2011-04-28 09:57:41 from Dmitriy Igrishin

pgsql-general by date

Next:	From: Dmitriy Igrishin	Date: 2011-04-28 09:40:40
	Subject: Re: Converting between varchar and float when updating
Previous:	From: Valeriano Cossu	Date: 2011-04-28 08:52:11
	Subject: Re: [ANNOUNCE] PostgreSQL Core Team