faza urmatoare (in Postgres):
stipo=> create table my_table (field float4);
CREATE
stipo=> insert into my_table values (1.5);
INSERT 288649 1
stipo=> insert into my_table values (1);
INSERT 288650 1
stipo=> insert into my_table values (0.35);
INSERT 288651 1
stipo=> select * from my_table;
field
-----
1.5
1
0.35
(3 rows)
stipo=> select * from my_table where field*100=35;
field
-----
(0 rows)
stipo=> select * from my_table where field=35/100;
field
-----
(0 rows)
-- STUPOARE
stipo=> select field*100 from my_table;
?column?
----------------
150
100
34.9999994039536
(3 rows)
???????????????????????????????????????????????????...
m-a dat pe spate, si ce-i mai sus e un palid exemplu fata de ceea ce
mi-a mai dat.
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2 pe
Mandrake 7.0 kernel 2.2.14]
Ce gresesc ??
Ce fac atunci cind am de comparat doua valori (0.35 cu 0.35) rezultate
din calcule simple (numai adunari) si ele de fapt sunt 0.349999994039536
si 0.3499999940323452 ?.
Asa ceva in Ingres n-am patit niciodata.
HELP !!
--
-------------------------------------------------------
Constantin Vasiliu * StipoSoft System Administrator
[EMAIL PROTECTED] * Linux Registered User #166419
-- tel:031/610215 ------------------- fax:031/610017 --
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
