Peter Eisentraut <[EMAIL PROTECTED]> 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. Investigat
--- On Fri, 8/22/08, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
From: Peter Eisentraut <[EMAIL PROTECTED]>
Subject: Re: [BUGS] range value problem with double precision [PG 8.3.3]
To: pgsql-bugs@postgresql.org, [EMAIL PROTECTED]
Date: Friday, August 22, 2008, 5:43 AM
Zahid Khan wrote:
Zahid Khan wrote:
> Hi ,
>
> I see one issue pg 8.3.3 .
>
> 1.
> According to the documentation of pg "The double precision type
> typically has a range of around 1E-307 to 1E+308 with a precision of at
> least 15 digits".
>
> ref:-
> http://www.postgresql.org/docs/8.3/static/datatype-numeric.htm
