Re: Converting between varchar and float when updating

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: Thomas Larsen Wessel <mrvelle(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Converting between varchar and float when updating
Date: 2011-04-28 10:11:26
Message-ID: 3145F8BC-C428-475F-9EC1-B04B2E086DCC@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2011-04-28 10:11:45 Re: Converting between varchar and float when updating
Previous Message Dmitriy Igrishin 2011-04-28 09:57:41 Re: Converting between varchar and float when updating