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

Поиск
Список
Период
Сортировка
От Daniel Schuchardt
Тема Divide a float4 by 1 - what is going on???????
Дата
Msg-id dgfn17$nts$1@news.hub.org
обсуждение исходный текст
Ответы Re: Divide a float4 by 1 - what is going on???????
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Roger Hand"
Дата:
Сообщение: Re: Setting WHERE on a VIEW with aggregate function.
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: pg_ctl reload breaks our client