Divide a float4 by 1 - what is going on??????? - Mailing list pgsql-general

Hi people,

can anyone explain what is going on here : ?

CIMSOFT=# CREATE TEMP TABLE test (n1 FLOAT4);
CREATE TABLE
CIMSOFT=# INSERT INTO test (n1) VALUES (2.456677);
INSERT 6571521 1
CIMSOFT=# SELECT * FROM test;
   n1
---------
 2.45668
(1 row)

CIMSOFT=# SELECT n1/1 FROM test;
     ?column?
------------------
 2.45667695999146
(1 row)

Why I get so many digits by a division with one? Anybody should have
learned that everything / 1 = everything ;-)

Thnx,
Daniel

PS :

PostgreSQL 8.0.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw