Re: pgsql: Allow numeric scale to be negative or greater than precision.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Allow numeric scale to be negative or greater than precision.
Дата
Msg-id 330928.1627402967@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql: Allow numeric scale to be negative or greater than precision.  (Simon Riggs <simon.riggs@enterprisedb.com>)
Ответы Re: pgsql: Allow numeric scale to be negative or greater than precision.
Список pgsql-committers
Дерево обсуждения 
Simon Riggs <simon.riggs@enterprisedb.com> writes:
> This is for migration?

Yeah, compatibility with some other DBMSes that allow this.

> Or does it mean very small values now occupy less space since we store
> fewer zeros?

It won't affect space consumption at all, as NUMERIC has never stored
leading or trailing zeroes.  (Modulo the fact that "zero" here means
a base-NDIGIT digit.)

            regards, tom lane

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Allow numeric scale to be negative or greater than precision.
Следующее
От: Fujii Masao
Дата:
Сообщение: pgsql: Avoid using ambiguous word "non-negative" in error messages.