Thread: ...

 

Doug Smith ha scritto:

 I have a field that is presently an int4 and I would like to change it and it's contents to a float. I tried building a new table and insert the data into the new field but I getthe error "type of <a> does not match target column <b>". Is there a convert function available? Sure would appriciate some help, besides spelling..ThanksDoug

prova=> create table test(i int4);
CREATE
prova=> insert into test values (1);
INSERT 188494 1
prova=> create table test1 ( f float);
CREATE
prova=> insert into test1 select float8(i) from test;
INSERT 188504 1
prova=> select * from test1;
f
-
1
(1 row)

--
                               - Jose' -

And behold, I tell you these things that ye may learn wisdom; that ye may
learn that when ye are in the service of your fellow beings ye are only
in the service of your God.                - Mosiah 2:17 -