On Wed, 9 Jul 2003, Philip Edelbrock wrote:
> phil=# select (3.85::float4)::float8;
> float8
> --
> 3.8490463257
> (1 row)
>
> (Or substitute 3.85 for any number with something other than 0 to the
> right of the decimal point, or pull the same values from any table whic
I ran into this oddity today and tested it on a few of our PosgreSQL
backends (all of which gave the same response):
phil=# select 3.85::float4*1;
?column?
--
3.8490463257
(1 row)
phil=# select 3.85::float4*1::float8;
?column?
--
3.849046
