Hi!,
I think i have found a bug.
I´ve tried it in PgSQL 7.3.5 & 7.4.1
When I do:
atisae_oct_1=# SELECT (1000/500/7)::FLOAT8 as v_numero;
v_numero
----------
0
(1 row)
atisae_oct_1=# SELECT 1000/500/7::FLOAT8 as v_numero;
v_numero
-------------------
0.285714285714286
(1 row)
atisae_oct_1=# SELECT (1000/500/7)::NUMERIC as v_numero;
v_numero
----------
0
(1 row)
atisae_oct_1=# SELECT 1000/500/7::NUMERIC as v_numero;
v_numero
------------------------
0.28571428571428571429
(1 row)
Why is different: 'SELECT (xxxxx)::FLOAT8' than 'SELECT xxxxx::FLOAT8'
Thanks in advance...
Rafa.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
