Index: float8-small-is-zero.out =================================================================== RCS file: /projects/cvsroot/pgsql/src/test/regress/expected/float8-small-is-zero.out,v retrieving revision 1.10 diff -u -r1.10 float8-small-is-zero.out --- float8-small-is-zero.out 8 Jun 2005 21:15:29 -0000 1.10 +++ float8-small-is-zero.out 5 Apr 2006 14:26:25 -0000 @@ -13,17 +13,9 @@ SELECT '-10e400'::float8; ERROR: "-10e400" is out of range for type double precision SELECT '10e-400'::float8; - float8 --------- - 0 -(1 row) - +ERROR: "10e-400" is out of range for type double precision SELECT '-10e-400'::float8; - float8 --------- - -0 -(1 row) - +ERROR: "-10e-400" is out of range for type double precision -- bad input INSERT INTO FLOAT8_TBL(f1) VALUES (''); ERROR: invalid input syntax for type double precision: "" @@ -377,7 +369,9 @@ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); ERROR: "-10e400" is out of range for type double precision INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); +ERROR: "10e-400" is out of range for type double precision INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); +ERROR: "-10e-400" is out of range for type double precision -- maintain external table consistency across platforms -- delete all values and reinsert well-behaved ones DELETE FROM FLOAT8_TBL;