Re: [SQL] avg() on numeric ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] avg() on numeric ?
Дата
Msg-id 11718.945472458@sss.pgh.pa.us
обсуждение исходный текст
Ответ на avg() on numeric ?  (<kaiq@realtyideas.com>)
Ответы Re: [SQL] avg() on numeric ?  (wieck@debis.com (Jan Wieck))
Список pgsql-sql
<kaiq@realtyideas.com> writes:
> test=> select avg(quota) from salesreps;
> ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0 scale 1723

> test=> select avg(sales) from salesreps;
> ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0
> scale 1723

Hmm ... there were some similar bugs reported a couple of months ago,
and I thought Jan would've fixed them by now.  Jan, if you don't have
time to look at this, let me know and I'll see if I can do anything
with it.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] Sub-select speed.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Sub-select speed.