The Hermit Hacker wrote:
> *** expected/float8.out Wed Jan 28 22:05:29 1998
> --- results/float8.out Sun Feb 1 21:30:39 1998
> ***************
> *** 9,17 ****
> QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
> ERROR: Bad float8 input format '-10e400'
> QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
> - ERROR: Bad float8 input format '10e-400'
> QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
> - ERROR: Bad float8 input format '-10e-400'
> QUERY: SELECT '' AS five, FLOAT8_TBL.*;
> five|f1
> ----+--------------------
>
> If I try this manually, teh 10e-400 and -10e-400 produce a value of
> "0"...are we considering this to be correct? Or is this a bug?
Bug. On my 980112 snapshot, I get
postgres=> select '-10e400'::float8;
ERROR: Bad float8 input format '-10e400'
Hope it hasn't changed.
- Tom