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
