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) ?
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 |