Divide a float4 by 1 - what is going on???????

Daniel Schuchardt <daniel_schuchardt@xxxxxx> · Sat, 17 Sep 2005 02:12:45 +0200

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org