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
