How do I convert exponential notation into numeric?

[billykopecki]

Good morning!

I have a data file that has a bunch of numbers that use exponential notation, i.e.:

4.275e-02
1.063e+00
8.532e-01
4.779e-01

Is there a way to convert these values into a numeric column in the copy command?

[id10t]

Hi!

[DELETED]

[billykopecki]

Oops! That does convert cleanly...

Code: Select all

dbadmin=> select '4.275e-02'::numeric cool;
  cool
---------
 0.04275
(1 row)

For some dumb reason I was doing this:

Code: Select all

dbadmin=> select '4.275e-02'::int oops;
ERROR 3681:  Invalid input syntax for integer: "4.275e-02"

Thanks for your help!