Re: Arbitrary precision arithmatic with pgsql - Mailing list pgsql-sql

On Aug 31, 2004, at 11:18 PM, Jan Wieck wrote:

> I agree that doing
>
>     select 2::numeric ^ 100;
>
> should emit some sort of a warning. Because what happens here is that 
> the numeric value is degraded to a float8 in order to use the 
> operator.

Would this be solved by overloading the ^ operator with the 
pow(numeric,numeric) function? Would the 100 be cast INT -> NUMERIC?

Michael Glaesemann
grzm myrealbox com