Re: range value problem with double precision [PG 8.3.3]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org, khanzahid235(at)yahoo(dot)com
Subject: Re: range value problem with double precision [PG 8.3.3]
Date: 2008-08-22 15:47:49
Message-ID: 13519.1219420069@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2008-08-22 16:16:04 Re: BUG #4372: TO_DATE with ISO week and day
Previous Message Hiroshi Saito 2008-08-22 15:36:26 Re: BUG #4371: Foreign Key constraints not working with ODBC