Re: Converting between varchar and float when updating

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Re: Converting between varchar and float when updating
Дата
Msg-id BANLkTik1fL6g59-4rWvrKVJbwBeeeWRUpw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Converting between varchar and float when updating  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Ответы Re: Converting between varchar and float when updating  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Список pgsql-general
Дерево обсуждения


2011/4/28 Vibhor Kumar <vibhor.kumar@enterprisedb.com>

On Apr 28, 2011, at 2:56 PM, Thomas Larsen Wessel wrote:

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

If you are sure bar contains float value, then try following:
UPDATE foo SET bar = bar::float * 2;
NB:  I am sure that OP is not sure :-) And since foo.bar is varchar,
it is better to use numeric instead of float :-)

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
// Dmitriy.


В списке pgsql-general по дате отправления:

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: Converting between varchar and float when updating
Следующее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: Converting between varchar and float when updating