Floating point exceptions.

Hi All,

I suspect this is an O/S or platform problem but can anyone offer any
suggestions as to how I might locate the cause.

DROP TABLE FLOAT8_TBL;
DROP

CREATE TABLE FLOAT8_TBL(f1 float8);
CREATE

INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
INSERT 277993 1

SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
ABORT: floating point exception! The last floating point operation either
exceeded legal ranges or was a divide by zero

The ABORT message comes from tcop.c when we are hit by a FPE signal by
the operating system.

.....

Here's some additional tests that seem to show the threshold.

postgres=> CREATE TABLE FLOAT8_TBL(f1 float8);
CREATE
postgres=> INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-150');
INSERT 278057 1
postgres=> SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
bad|?column?
---+--------
| 1
(1 row)

postgres=> INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-151');
INSERT 278058 1
postgres=> SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
ABORT: floating point exception! The last floating point operation either
exceeded legal ranges or was a divide by zero

Keith.