I am getting a float4 regression test failure.  I have extracted the SQL from 
both the float4 and float8 tests below.  
Both should return NAN

I looked at the code,  The float4div does the operation as float8's then checks 
the value.  The value is a valid 
float8 NAN.  The call to CheckFloat4Val is missing a cast back to float4.  If I 
put the cast in I get the expected 
results (NAN).


SELECT 'Infinity'::float4 / 'Infinity'::float4;
psql:test.sql:1: ERROR:  type "real" value out of range: overflow

SELECT 'Infinity'::float8 / 'Infinity'::float8;
 ?column? 
----------
      NaN
(1 row)


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to