Hi, Well, I discovered a strange behavior (ie 85/0.0085 <> 10000 ) Is my SQL wrong or is it postgres ? We are running 7.02 (but also 6.x) on a alpha (alphaev6) box. Thanks in advance. jc Here is a snapshot jctest=> create table eigthyfive ( cs float4, csbytenthousand float4, csbyhundred float); CREATE jctest=> insert into eigthyfive VALUES (88,0.0088,0.88); INSERT 7973003 1 jctest=> insert into eigthyfive VALUES (86,0.0086,0.86); INSERT 7973004 1 jctest=> insert into eigthyfive VALUES (85,0.0085,0.85); INSERT 7973005 1 jctest=> insert into eigthyfive VALUES (84,0.0084,0.84); INSERT 7973006 1 jctest=> select * from eigthyfive ; cs | csbytenthousand | csbyhundred ----+-----------------+------------- 88 | 0.0088 | 0.88 86 | 0.0086 | 0.86 85 | 0.0085 | 0.85 84 | 0.0084 | 0.84 (4 rows) jctest=> select * from eigthyfive where (cs/csbytenthousand=10000); cs | csbytenthousand | csbyhundred ----+-----------------+------------- 88 | 0.0088 | 0.88 86 | 0.0086 | 0.86 84 | 0.0084 | 0.84 (3 rows) *** oh oh 85 disappeared ! *** BUT jctest=> select (85/0.0085=10000); ?column? ---------- t (1 row) jctest=> select * from eigthyfive where (cs/csbyhundred=100); cs | csbytenthousand | csbyhundred ----+-----------------+------------- 88 | 0.0088 | 0.88 86 | 0.0086 | 0.86 85 | 0.0085 | 0.85 84 | 0.0084 | 0.84 (4 rows) ** 85 is back ** jctest=> insert into eigthyfive VALUES (85,0.00085); INSERT 7973007 1 jctest=> select * from eigthyfive where (cs/csbytenthousand=100000); cs | csbytenthousand | csbyhundred ----+-----------------+------------- 85 | 0.00085 | (1 row)
begin:vcard n:Pazzaglia;Jean-Christophe tel;fax:+357 (0) 2 750 654 tel;work:+357 (0) 2 750 750 x-mozilla-html:FALSE url:http://www.albourne.com org:Albourne; adr:;;3, Demetiou Vikella Street;Nicosia;;1061;Cyprus version:2.1 email;internet:[EMAIL PROTECTED] note;quoted-printable:altenative [EMAIL PROTECTED] x-mozilla-cpt:;-6144 fn:Jean-Christophe Pazzaglia end:vcard
