range value problem with double precision [PG 8.3.3]

From: Zahid Khan <khanzahid235(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: range value problem with double precision [PG 8.3.3]
Date: 2008-08-22 11:38:33
Message-ID: 231107.29424.qm@web54504.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2008-08-22 12:43:05 Re: range value problem with double precision [PG 8.3.3]
Previous Message Zahid Khan 2008-08-22 11:29:48 BUG #4371: Foreign Key constraints not working with ODBC