Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group