Re: Converting between varchar and float when updating

2011/4/28 Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)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(dot)kumar(at)enterprisedb(dot)com
> Blog:http://vibhork.blogspot.com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.