Good day. I may be misunderstanding the NUMERIC type description in the manual, so can anyone please help me with this? Description says: "The scale of a numeric is the count of decimal digits in the fractional part, to the right of the decimal point. The precision of a numeric is the total count of significant digits in the whole number, that is, the number of digits to both sides of the decimal point. ... Integers can be considered to have a scale of zero. " However, I am not able to insert numbers that have number of digits equal to the precision and the scale equal to 0. F.E.: CREATE TABLE test.test ( rate numeric(5,1) ) INSERT INTO test.test VALUES (10000) Generates an error: ERROR: numeric field overflow SQL state: 22003 Detail: A field with precision 5, scale 1 must round to an absolute value less than 10^4. So, does the precision part of the numeric type really means number of digits to the left of the decimal point, or what ? Thanks. -- Regards, Nurzhan Kirbassov. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
