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:18:36
Message-ID: EB16BC9B-BDA1-473A-B15B-7B2222FCB9FC@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 28, 2011, at 3:41 PM, Dmitriy Igrishin wrote:

> Only one point, Vibhor. I believe that varchar data type was chosen for
> exact storage of numeric values. According to chapter 8.1.3 of the doc.
> for this case the usage of numeric is preferred over floating data types.
Ah! Got it. This I have missed.

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 c k 2011-04-28 11:19:08 plpython module import errors
Previous Message Dmitriy Igrishin 2011-04-28 10:11:45 Re: Converting between varchar and float when updating