float8.pat

text/plain

Download

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;