Numeric 508 datatype
От | Simon Riggs |
---|---|
Тема | Numeric 508 datatype |
Дата | |
Msg-id | 1132161229.4959.12.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Numeric 508 datatype
Re: Numeric 508 datatype Re: Numeric 508 datatype |
Список | pgsql-patches |
Now we're into 8.2devel mode, its time to submit the previously discussed patch that: - reduces Numeric storage format by 2 bytes - limits scale to +/- 508 decimal places This is sufficient to allow Numeric to continue to be used as the default numeric representation for all numbers in the parser. Passes: make check on cvstip, as well as some tests not in there. Code comments explain the new format and consequences. As previously agreed, reviewing this is a 2 stage process: 1. review/possibly agree OK to commit 2. check with everybody on GENERAL that the restriction to 508 is acceptable Figure there's no point doing (2) until we agree the proposal/code is workable. As Atsushi-san point out, there is also come CPU optimization to be done on Numeric comparison, and also on other areas such as aggregation. I've not done this yet. Best Regards, Simon Riggs
Вложения
В списке pgsql-patches по дате отправления: