| From: | Stuart Rison <stuart(at)ludwig(dot)ucl(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | limits of float8 |
| Date: | 1999-07-01 12:11:07 |
| Message-ID: | v04020a04b3a107be9d35@[128.40.242.190] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear all,
What are the limits of float8?
The user guide says variable-precision, 14 decimal places range but I'm not
sure how that translates to a minimum value.
I'm asking because I'm storing probability scores (range 0 to 1) with some
scores very small indeed.
The very small scores are all entered in scientific notation.
>From experimentation, the smallest value I seem to be able to enter is
around 2.225e-308. Is this 'correct'?
This is PG 6.4 compiled with cc under Irix 5.3.
Cheers,
Stuart.
+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
+-------------------------+ 91 Riding House Street |
| Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. |
| Fax. (0171) 878 4040 | stuart(at)ludwig(dot)ucl(dot)ac(dot)uk |
+-------------------------+--------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Bitmead | 1999-07-01 12:16:29 | Re: [GENERAL] JOIN exclusion problem |
| Previous Message | Stuart Rison | 1999-07-01 10:26:46 | Re: [GENERAL] JOIN exclusion problem |