Friday, August 22, 2008

[BUGS] range value problem with double precision [PG 8.3.3]

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.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.

No comments: