At 23:27 22/11/00 -0500, Tom Lane wrote:
>Philip Warner <[EMAIL PROTECTED]> writes:
>>
>> Is there a reason why it doesn't promote float8 to numeric?
>
>Mixing exact and inexact numerics (to use the
>spec's terminology) can hardly be expected to produce an exact result.
I suppose it's a question
Philip Warner <[EMAIL PROTECTED]> writes:
> select cast(sum(f1) as float8)/sum(f2) from tsc;
> Now in 7.1 this breaks with:
> ERROR: Unable to identify an operator '/' for types 'float8' and 'numeric'
> You will have to retype this query using an explicit cast
> Is there a reason w
There is a minor breakage of existing apps that occurs with current CVS.
In 7.0 doing the following:
create table tsc(f1 int4 , f2 int4);
insert into tsc values(1,4);
select sum(f1)/sum(f2) from tsc;
would actually result in zero, since it worked with integers throughout. As
a resu
