Re: Arbitrary precision arithmatic with pgsql

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Arbitrary precision arithmatic with pgsql
Дата
Msg-id D8906004-FB59-11D8-A2A0-000A95C88220@myrealbox.com
обсуждение исходный текст
Ответ на Re: Arbitrary precision arithmatic with pgsql  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Arbitrary precision arithmatic with pgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Arbitrary precision arithmatic with pgsql