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)
Список
Дерево обсуждения
pgsql: Allow numeric scale to be negative or greater than precision. Dean Rasheed <dean.a.rasheed@gmail.com>
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. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Allow numeric scale to be negative or greater than precision. Simon Riggs <simon.riggs@enterprisedb.com> 
Simon Riggs  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
Дата:
Следующее
От: Fujii Masao
Дата:
FAQ