David W Noon wrote:
On Tue, 6 Oct 2009 12:20:11 +0600, Nurzhan Kirbassov wrote about
[GENERAL] numeric field overflow:
[snip]
So, does the precision part of the numeric type really means number of
digits to the left of the decimal point, or what ?
No.
The precision is the *total
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
On Oct 5, 2009, at 11:20 PM, Nurzhan Kirbassov wrote:
So, does the precision part of the numeric type really means number of
digits to the left of the decimal point, or what ?
NUMERIC is behaving as documented. The way to think of it is when you
are inserting:
INSERT INTO
On Tue, Oct 6, 2009 at 12:20 AM, Nurzhan Kirbassov km.same...@gmail.com wrote:
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
However, I am not able to insert numbers that have number of digits
equal to the precision and the scale equal to 0.
Scale applies to the *column*. You defined your column to have a scale of 1,
so you can't just claim that your value has scale 0 and claim an extra digit
to the left of the
On Tue, 6 Oct 2009 12:20:11 +0600, Nurzhan Kirbassov wrote about
[GENERAL] numeric field overflow:
[snip]
So, does the precision part of the numeric type really means number of
digits to the left of the decimal point, or what ?
No.
The precision is the *total* number of decimal digits, both