Re: range value problem with double precision [PG 8.3.3] - Mailing list pgsql-bugs

From Tom Lane
Subject Re: range value problem with double precision [PG 8.3.3]
Date
Msg-id 13519.1219420069@sss.pgh.pa.us
Whole thread Raw
In response to Re: range value problem with double precision [PG 8.3.3]  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Peter Eisentraut <peter_e@gmx.net> writes:
> The following, however, appears to be a bug:

> peter=# select '1E-324'::float8;
> ERROR:  22P02: invalid input syntax for type double precision: "1E-324"
> LOCATION:  float8in, float.c:431

I see this behavior on Fedora 9, but not on HPUX.  Investigation shows
that F9's strtod returns EDOM not ERANGE for this case.  Seems like a
glibc bug ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: BUG #4371: Foreign Key constraints not working with ODBC
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #4372: TO_DATE with ISO week and day