2011/4/28 Vibhor Kumar <vibhor.kumar@xxxxxxxxxxxxxxxx>
If you are sure bar contains float value, then try following:
On Apr 28, 2011, at 2:56 PM, Thomas Larsen Wessel wrote:
> UPDATE foo SET bar = TO_VARCHAR( TO_FLOAT(bar) * 2); -- INCORRECT!!!!
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 :-)
it is better to use numeric instead of float :-)
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@xxxxxxxxxxxxxxxx
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
// Dmitriy.
