float values at the extreme... when did things change?

[Sean Chittenden]

While PostgreSQL runs its regression tests fine on 4.X, in recent 5.X
the return values of floats have changed and I'm trying to figure out
the best way to detect this.

Under older versions of FreeBSD, the following was true:

  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
  ERROR:  Input '10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Input '-10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');

Small values were considered zero.  Now, however, small values are out
of range:

  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Input '-10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
  ERROR:  Input '10e-400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
  ERROR:  Input '-10e-400' is out of range for float8

No doubt that things are more correct in their current incarnation,
however, when did this change (not sure where to look) and was there a
__FreeBSD_version bump regarding this?  -sc


PS Reason this is on standards is because from what I can tell,
-CURRENT's float handling is more standards compliant than previously
and figure someone on this list had a hand in making this the case.

-- 
Sean Chittenden
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 202 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-standards/attachments/20030507/69942936/attachment.bin