Re: Converting between varchar and float when updating - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: Converting between varchar and float when updating
Date
Msg-id 3145F8BC-C428-475F-9EC1-B04B2E086DCC@enterprisedb.com
Whole thread Raw
In response to Re: Converting between varchar and float when updating  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: Converting between varchar and float when updating
List pgsql-general
On Apr 28, 2011, at 3:22 PM, Dmitriy Igrishin wrote:

> NB:  I am sure that OP is not sure :-) And since foo.bar is varchar,
> it is better to use numeric instead of float :-)


Now, this make to ask question, why numeric? How its better than float?

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


pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Converting between varchar and float when updating
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Converting between varchar and float when updating