10.08.2017 20:29, Carlos H. Cantu wrote:


Can someone explain why I can't change a field from numeric (15,4) to
numeric (15,6) [error is "New scale specified for column TESTE must be
at most 4."], but can change it to numeric (17,6) ?

Because (15, 6) provides less integral precision (9 digits instead of 11) and theoretically some existing values may not fit, making those records unreadable.

e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 6).


Dmitry

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to