Re: to_number function

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