| From: | "Pablo Oses" <opablo(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1888: bug in cast from float4 to float8 |
| Date: | 2005-09-17 03:00:50 |
| Message-ID: | 20050917030050.D0CCBF0B36@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1888
Logged by: Pablo Oses
Email address: opablo(at)gmail(dot)com
PostgreSQL version: 8.0.x and 7.2.x
Operating system: redhat, slackware and win32
Description: bug in cast from float4 to float8
Details:
this is *really* simple
execute something like this:
select cast(123.456::float4 as float8)
what do you think its the answer ? 123.456 ?
well pgsql 7.2.2, 8.0.0, 8.0.1 and 8.0.3 (all i have used) answers this:
123.456001281738 which is WRONG
bye and thanks for a wonderfull contribution for the free software comunity
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-17 13:46:52 | Re: BUG #1888: bug in cast from float4 to float8 |
| Previous Message | Bruce Momjian | 2005-09-16 19:39:38 | Re: BUG #1871: operations with data types |