Re: to_number function

From: Igor Romanchenko <igor(dot)a(dot)romanchenko(at)gmail(dot)com>
To: "manno_it(at)libero(dot)it" <manno_it(at)libero(dot)it>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: to_number function
Date: 2012-11-15 13:52:18
Message-ID: CAP95Gq=9gJeSWnx8jsoF8Wffqn3CRe7c+44WeGmThG4sYreH+w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Nov 14, 2012 at 11:30 PM, manno_it(at)libero(dot)it <manno_it(at)libero(dot)it>wrote:

> Hello people,
> it is my first post here! Thank you all for any suggestion and help.
>
>
> I'm a newbie in PostgreSQL.
>
> I'm working on a PostgreSQL table (*evaluations*) imported from an .xls
> one in which a column named "score" stores some values. To be able to
> import the table from .xls I had to set the TYPE of the PostgreSQL column
> "score" to TEXT, because the data stored are registered in different ways
> (previous values were generated by FileMakerPro...): NULL, or a number in
> different ways like: 3 or 3,5, or 3,50 or 3,75... to 10 (which is the
> maximum number accepted in this column.
>
> I need to convert the TYPE of my column from TEXT to NUMERIC (with the
> possibility to have decimal numbers with a maximum of 2 characters after
> the comma). I surfed the PostgreSQL Guide finding the to_number function,
> but it is really to difficult for me in this moment to understand the way
> to use it properly according to the variability of my data in the column
> "store".
> Anyone could help me, please?
> Bests,
> Mauro
>
>

Hi Mauro.
Can you give us some sample data for your problem (create table and some
inserts with sample data) ?

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Merlin Moncure 2012-11-15 17:00:27 Re: Query on JSON field type
Previous Message James David Smith 2012-11-14 23:23:09 Re: to_number function