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

From Zahid Khan
Subject range value problem with double precision [PG 8.3.3]
Date
Msg-id 231107.29424.qm@web54504.mail.re2.yahoo.com
Whole thread Raw
Responses Re: range value problem with double precision [PG 8.3.3]
List pgsql-bugs
Hi ,

=A0I 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:-
=A0http://www.postgresql.org/docs/8.3/static/datatype-numeric.html

but in PG8.3 the values less then minimum range are being inserted.

e.g
. on insertion of 1E-308 we should get an error of "out of range or
underflow value" but this value is being accepted by server.



Thanks,
Zahid K.



=20=20=20=20=20=20=

pgsql-bugs by date:

Previous
From: "Zahid Khan"
Date:
Subject: BUG #4371: Foreign Key constraints not working with ODBC
Next
From: Peter Eisentraut
Date:
Subject: Re: range value problem with double precision [PG 8.3.3]